Difference between basing pivot on excel list or other pivot table

  • Thread starter Thread starter Gio Bacareza
  • Start date Start date
G

Gio Bacareza

What is the difference between basing the pivot table on excel list of other
pivot table report? thanks
 
Hi Gio

The big pro for basing off another Pivot Table is the reservation of
memory. The big con is that both are linked. This means much of what you
do to one, effects the other. Perphaps the one that most get caught with
is the 'grouping' of data. Group one Pivot Table and any others based
off it will also be grouped.

I will often base one PT off another to save the user from having to
drag fields about.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Pivot table 1
Pivot table report invalid 0
Pivot Table Help! 1
How to base a pivot table on another pivot table? 3
Excel 2010 Slicer Connection / Pivot Table Problem 3
Consolidate Pivot Tables/Cache using Excel 2003 1
Excel VBA For excel 0
Excel2007 | I want to create a pivotTable from a different data, and different sheets 0

Back
Top