ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sum a pivot table field as a calulated field (https://www.excelbanter.com/excel-discussion-misc-queries/171650-sum-pivot-table-field-calulated-field.html)

Jerome

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



All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com