LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Variance Nate Excel Discussion (Misc queries) 2 March 12th 10 09:55 AM
How do a justify a variance in my budget. Donna Feeney Excel Worksheet Functions 2 November 5th 08 12:45 AM
Pivot Table showing number "1" instead of actual result Pendelfin Excel Discussion (Misc queries) 1 May 20th 08 01:46 PM
Excel formula to calculate % difference when actual 1, budget -48 yuppy flyer Excel Discussion (Misc queries) 1 March 23rd 07 12:34 PM
Calculate % variance on previous quarters. Quarter %, etc. pivot DaveC Excel Discussion (Misc queries) 1 August 8th 05 06:45 PM


All times are GMT +1. The time now is 10:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"