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
10,491 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,420 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
510 views
0 votes
1 answer
+2 votes
2 answers
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 23,260 points
6,198 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,420 points
966 views
0 votes
1 answer

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,420 points
502 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,236 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,422 views
0 votes
1 answer
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,420 points
483 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP