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