Difference between basing pivot on excel list or other pivot table

G

Gio Bacareza

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

Dave Hawley

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 ***
 

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

Top