View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrchong
 
Posts: n/a
Default Pivot table column creation: Mission Impossible ?

I have a table with these field headers Product/Status/USD:-
A/Actual/100
A/Budget/90
A/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.