View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jerome Jerome is offline
external usenet poster
 
Posts: 20
Default sum a pivot table field as a calulated field

Hi there

I'd like to know if its possible to sum the column field in a pivot table
and display the result as a calculated field.

Sum of Total Region
Item Alberta Total(Alberta) Ontario
Binder 1279.36 4973.44 5762.63
Desk 825 4973.44 875
Pen 151.24 4973.44 539.73
Pen Set 4973.44 2421.39
Pencil 231.12 4973.44 1540.32
Grand Total 2486.72 4973.44 11139.07

Thank you for your help in this regard.

Jerome