Hi,
I have several tabs reflecting expenses for every month, where I then have consolidated it in a pivot table and it looks good and just as I want it.
However, I want to have one Summary tab where I consolidate the monthly expenses from the tabs so I see the how much I have spent on each category each month.
I like to have a structure like this where I consolidate the tabs into one summary tab. Today I have the monthly tab in pivot table, but I having problem to get a nice summary tab. Anyone who can guide me here?
Month Category Expense
Jan Total 90
- Kids 10
- Housing 30
- Electricity 20
- Cars 15
- etc 15
Feb Total 50
- Kids 10
- Housing 15
- Electricity 5
- Cars 10
- etc 10
Total 140
Bookmarks