Pls help on Pivot Table

[hkappleorange]

I have a table with these field headers Product/Status/USDApple/Actual/100
Apple/Budget/90
Apple/Variance/10

I have created a Pivot Table with
Product as row field (A or B)
Status as Column field (Actual, Budget, Variance)
USD as Value

It looks fine like this but I need to create an additional column called
Variance % which is (Variance/Budget x 100%).

Please urgently advise how to create this new % column within Pivot Table.

Thanks.

 

[Guest]

Hi there,

it seems, you need to do calculation with the Occurances of One field
(Status => Variance & Budget )

activate the Pivot (clicking into 1 ColumnData cell, with the marker), you
can use the PivotTable toolbar, then
click on PivotTable (sorry, i have local Excel, but should be the same in
EN) dropdown button
then select Function (or maybe it is called Calculation), then Calculated
ITEM (not field).
then add a name: variance %
then add the calculation itself (selecting the Status field on the left hand
side) => the Actual, Budget, Variance will appear on the right box, and then
by doubleclicking each Item's name like: = 'Variance' / 'Budget' * 100%

did it work?

Best regards,
ANdras
(Hungary)