Hi - I am trying to fix a problem in a budget spreadsheet I created. I have a tab where all my master data is stored (hundreds of line items with different columns for categories, locations, etc.). I have created pivot tables to show comparisons of those categories, but then I'm also trying to do an overall budget view on one tab. I had linked the cells back to the pivot table charts, but when I refresh the pivot tables, my data in the overall chart doesn't update. So, how do I summarize 200 lines of data into multiple categories in one table with the sum of the budget items for each?
Solved by I. B. in 27 mins