Hi,
Inside the attached file are 3 tabs, in the tab marketing it is the amalagmation of all marketing budgets, in tab magazines is the amalagmation of all magazine budgets.
In the overview tab you can see the red colour pivot tables I've added rows or columns to give me a running total of my budget. Is there a way to do this in calculated fields?
I feel like I'd need to add ablank column but can't see how to do this? Am I just going about this the wrong way?
Last year each budget had it's own tab on a spreadsheet, it becomes a bit unruly, I thought pivot tables would solve this but it's proving a bit more tricky.
Thanks very much.
Bookmarks