Forum Discussion
summarize multiple pivot tables into new pivot table
Hi. I have a workbook with multiple sheets containing pivot tables. I need to summarize these onto one worksheet.
I've tried consolidating and creating a pivot table including the data from the other pivot tables.
Maybe I'm just not doing this right (definitely not an expert). Any ideas?
1 Reply
- Are these pivot tables using the same datasource? If not, you will have to construct a combined datasource for the summary pivot table or -alternatively- combine the pivottables using plain formulas (not recommended as they will not change if your number of categories (# of unique values in row/column/page fields) changes.
