Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Is it possible to create nested Pivot tables..? (A new Pivot table from the data aggregated from Pivot table)

user-image
Question added by Abdul Khader Shaik , Cyber Crime Lawyer , Grofers
Date Posted: 2017/12/27
Firas Shahadi
by Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

By Default, MS Excel will not allow a pivot table to be a source for another Pivot table. And this is logic, as the range of the range is always changing.

But here is my workaround.

you can copy and paste as link all the columns that the previous pivot table occupied to another sheet.

Then, you can use that new range, which contains a linked cells to the original pivot table.

Done.

Thank you for the question

 

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.