View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spencer Hutton Spencer Hutton is offline
external usenet poster
 
Posts: 45
Default pivot table calculated field

is it possible to create a calculated field in a pivot table that divides a
field value by the grand total of the table?
the field is called "Amount" and i want to find the % variance between the
amount for each and the grand total. TIA.