Forum Discussion
How do I create a Overview for budget from PivotTable that calculates automatically?
I'm using the Family budget template which is not functioning perfectly on Mac, and I have thus been doing some editing on my own and created a manually Pivot Table (got the help from you here for this).
However, now I can't get the hang on how to edit the Overview summary to make it work like it should, and I imagine it's because I've done other edits.
Can someone help guide me how to make the Overview work properly? It should automatically calculate from two different tables.
I'm attaching a printscreen so you can see what I'm after. The green rectangle where the yellow pop-up is displaying is the Overview (it's in Swedish now). It should get the information to summarise from the field below (inkomst total) and tab nr 2 (utgifter).
Thank you!
1 Reply
- Riny_van_EekelenPlatinum Contributor
sofiamatsson Hi again, perhaps the attached file helps. It's the original template file, with the Data Model pivot table replaced by a regular one and a Pivot Chart based on that one. If you still have problems getting it incorporated in your own file, send me a direct message. Då ska jag hjälpa dig på Svenska. Trevlig helg!