Register now or log in to join your professional community.
Is it done by programming Macros,,?
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