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 , IT & Ops Manager , TheSmartlabs
Date de publication: 2017/12/27
Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

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