Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table Calculated Fields
Hi I have a pivot table with one data field which is "Revenue". On the pivot
table I've split the revenue by the Ledger field which holds the values of "Actual" or "Budget". I want to be able to add a third field in which effectively is Actual - Budget, is this possible? If so how would I do this? Is it possible to change the Grand Total Field from Grand Totalling but to do a subtraction of the Actual - Budget? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table calculated fields | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Fields | Excel Discussion (Misc queries) | |||
Pivot table and calculated fields | Excel Discussion (Misc queries) | |||
Pivot Table with Calculated Fields | Excel Discussion (Misc queries) | |||
Sum of Calculated fields in Pivot Table | Excel Discussion (Misc queries) |