Create a pivot table from another pivot table

Excel doesn’t support creating a pivot table from another pivot table directly, but it is very easy to do so using named range. 

Please refer to my previous blog about how to use named ranges. The difference is that you might want to change the last parameter – the range width – to include more columns in the named range:

=OFFSET(javaChart!$A$4,0,0,COUNTA(javaChart!$A$4:$A$10000)-1,1)

Now, from the menu tab, “Pivot Table”, input the named range:

That is all!