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 ...
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.