Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Abdul Khader Shaik , Cyber Crime Lawyer , Grofers
Date de publication: 2017/12/27
Firas Shahadi
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?