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