Pivot Table - Calculated Field on "Show Value As" cells

[baseball17bucks]

Hi,

I have a pivot table with the following field settings:

Rows: Account #
Columns: Month (and Values)
Values: Budget, Estimated Total Cost, Budget (Show Value As: Difference from prior Month), Estimated Total Cost (Show Value As: Difference from prior Month)

I have two months of data (December and January).

Note that:
Budget (Show Value As: Difference from prior Month) - shows how much the budget changed from December to January.
Estimated Total Cost (Show Value As: Difference from prior Month) - shows me how much the Estimated Total Cost changed from December to January.

If I combine these two "Show Value As" columns together, then I'd get "Total Estimated Cost Change due to Favorable/Unfavorable" performance, which is what I want.

QUESTION: How can I add a Calculated Field that will add "Show Value As" columns together? Thanks!

 

[Andrew Poulsom]

You can't do that with a Calculated Field because it will use the raw data (Sum) not the data as shown.