sum a pivot table field as a calulated field

J

Jerome

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table: configuring calculated field correctly 4
Total Not Summing Correctly on Calculated Fields in Pivot Table 0
Pivot Table Calculated Field - Sum/count 1
Pivot Table Calculated Field 0
Formula in Pivot Table 0
pivot tables: Calculated fields among *row* items 0
Pivot Table - Calculated Field 2
Calculated Field Total in Pivot Table 5

Top