View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
YY san.[_2_] YY san.[_2_] is offline
external usenet poster
 
Posts: 27
Default Pivot table to calculate variance showing budget and actual.

Hi,
I know this is rather simple, but I just could not get it right. I have this
data:

Expenese Type Amt Scenario
Staff cost 200 Budget
Admin cost 75 Budget
Office rent 5000 Budget
Staff cost 100 Actual
Admin cost 45 Actual
Office rent 300 Actual
I am able to get the difference using the pivot table "Difference from", but
it only showed that single column. I would like my pivot table to show:

Expenese Type Budget Actual Variance
Staff cost 200 100 100
Admin cost 75 45 30
Office rent 5000 300 4700

Appreciate all guidance and hints.
Thanks!