pivot tables

G

Guest

I want get my pivot table to automatically split the results by the drop down
list at the top into sperate worksheets - is this possible?
 
R

Roger Govier

Hi Kim

If you have a field in the Page area, then from the PT toolbar, choose
Show Pages, select which Filed (if there is more than one) and Excel
will create a separate sheet for each Page field item, each containing a
subset of the raw data that went to make up the original data.
 

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

Pivot Tables in 2007 1
Different ways to build Pivot table 1
Pivot Table using dynamic worksheets 2
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table Update 3
2003 Pivot Table Filter (items dropped in the Page Fields) 1
How to refresh drop-down list of pivot table 3
Getpivotdata with a lookup functions 1

Top