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![]()
Bookmarks