+ Reply to Thread
Results 1 to 1 of 1

Problem comparing annual budget and monthly actual expenses in pivot table

  1. #1
    Registered User
    Join Date
    05-19-2009
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Problem comparing annual budget and monthly actual expenses in pivot table

    Hi!

    I have one question. I would simplify the problem as follows:

    - I want to compare actuals vs budget
    - BUT Actuals are on monthly basis and my budget is annual
    - I don't want to divide my budget or to work on a monthly budget
    - I want to see in a pivot table the actuals detailed by month and the totals compared to my annual budget.

    I join a file for example. The solution I tried was to insert a line in the 'database' dedicated to the budget. Is this the way you do it usually? I mean my problem is much more complicated and my excel file much much bigger, but I want to make sure I am on a good beginning before complicating things.

    Thanks in advance for your opinions
    Attached Files Attached Files
    Last edited by Leooo; 05-19-2009 at 05:13 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1