Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Variance | Excel Discussion (Misc queries) | |||
How do a justify a variance in my budget. | Excel Worksheet Functions | |||
Pivot Table showing number "1" instead of actual result | Excel Discussion (Misc queries) | |||
Excel formula to calculate % difference when actual 1, budget -48 | Excel Discussion (Misc queries) | |||
Calculate % variance on previous quarters. Quarter %, etc. pivot | Excel Discussion (Misc queries) |