Use Excel pivot table as data source for another Pivot Table

Question

I have an excel pivot table that draws its data from a raw table. This pivot table groups and sums the rows in numerous ways.

The output of this new pivot table will now serve as the data source for another pivot table that will further modify this data.

Is Excel capable of handling this? You could call it "nested pivot tables," I suppose.

Answer 1

Press the keys Alt+D+P in a new sheet where you wish to create a new pivot table. Select "Microsoft Excel list of databases" from the list of available data sources. Select the pivot table you wish to utilize as a source by clicking Next (select starting with the actual headers of the fields). This range is probably rather static, so you would have to resize it if you refreshed the source pivot and it changed in size. Hope this was useful.