I have an Excel worksheet which is regularly populated with daily expenses:
Then to extract a report on the amount of money spent on each category, I simply use a pivot table like below:
I am not sure how to integrate the planned budget into this report. Suppose I've got the planned budget stored in a separate table:
How can I seamlessly integrate this plan into my report so that I can know how much have been spent in each category according to the plan? i.e. What's the best way to get a report like this (all in one table):
Is it possible to manipulate the pivot table fields to get such report?