Use Excel pivot table as data source for another Pivot Table

0 votes
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.
Nov 10, 2022 in Others by Kithuzzz
• 38,010 points
12,531 views

1 answer to this question.

0 votes
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.
answered Nov 11, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
0 answers

Is it possible to create Pivot Chart with source data as Pivot Table using Apache POI?

Using apache POI separately, I can make ...READ MORE

Dec 15, 2022 in Others by Kithuzzz
• 38,010 points
621 views