| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Field in Field List but Not Source Data | Excel Discussion (Misc queries) | |||
| Pivot Table Field | Excel Discussion (Misc queries) | |||
| sum field is zero when using Pivot table | Excel Discussion (Misc queries) | |||
| How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
| Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
Linear Mode
