Many thanks. However this method only works if there is one VALUE Column
"Actual", another VALUE Column of "Budget".
My case is there is only ONE value column called US$, and there is a
dimension called Status which has values of Actual or Budget.
How could I proceed ?
Pls help....
"Gary Brown" wrote:
You need to insert a Calculated item.
Highlight Status in you Pivot table column and select Pivot Table,
Formulas, Calculated Item from the Pivot Table Tool bar, Give the
formula a name (ie Variance%), then click on the Status Field in the
Fields window, and then click on Variance in the Items window and click
on Insert Item. In the formula bar edit this with a / at the end of the
formula and then click on Budget from the items pane and click on
Insert item, finally edit the formula with *100 and click on OK.
You should now have a pivot table with a variance field. You may need
to format accordingly.
Good Luck
--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=534087