On the PivotTable toolbar, choose PivotTableShow Pages

tkaplan wrote:
I forgot how to do this:

If I have a pivot table that the page headings is of four regions, how
can i create four seperate pivot tables, each one being one of the
regions?

(I know I can do this manually but I know that there is a way to
duplicate it automatically to change for the regions)

Thanks in advance.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html