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 in Others by Kithuzzz
• 20,660 points
40 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 by narikkadan
• 37,660 points

Related Questions In Others

+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 in Others by gaurav
• 22,040 points
274 views
0 votes
1 answer

(Excel) Data Entry Form inputting data into table

Solution  Fill in all the fields in your ...READ MORE

answered Oct 15 in Others by narikkadan
• 37,660 points
49 views
0 votes
1 answer

How can I sort one set of data to match another set of data in Excel?

In addition, INDEX MATCH is a more ...READ MORE

answered Oct 29 in Others by narikkadan
• 37,660 points
38 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

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

answered Oct 7 in Others by narikkadan
• 37,660 points
71 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 in Others by narikkadan
• 37,660 points
30 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 in Others by Edureka
• 13,640 points
137 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 in Others by Edureka
• 13,640 points
230 views
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 in Others by narikkadan
• 37,660 points
63 views
0 votes
1 answer

How to use VBA in Excel for Google Search?

Try this: Private Const LicenseRegistration As String = ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
117 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