Pivot table variance (help!)

J

John

If this is my data list:

Field names:
PL Type, PL Version, Product, Amount

Records:
1. Forecast, version A, productX, $100
2. Budget, version B, productX, $90

How do I get the pivot table to show a variance between these two
records? I tried doing a "calculated item" using the PL Type fields
(Forecast minus Budget), but this only results in two new columns
showing the same amounts for each PL Type.

How do I have a column added to show the $10 variance---the problem is
when there there are two fields being used for the variance (PL Type
and PL Version).

Any suggestions?
 
Top