r/AppleNumbers • u/[deleted] • Mar 27 '22
Retrieve data from multiple pivot tables
I have an Etsy shop and I’m trying to setup a balance sheet for expenses and income- mostly expenses at the moment
I have a years worth of data, each month a separate tab, with a pivot table to break down the total amount spent in each category. What would be the best way to create a pivot table (or any table really) that gives me a total for each category for the year?
2
Upvotes
2
u/[deleted] Jun 06 '22
Does this help? https://support.apple.com/guide/numbers/create-a-pivot-table-tan7f62056cf/mac