Y
YY san.
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!
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!