Pivot Table
 

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.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=387505

Hi tk-

How about dragging the Region field name to the 'Drop Page Fields Here' box?

HTH |:)

"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.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=387505

i've done that. but now i want to duplicate the entire pivot table on
four seperate pages, one for each region.
there was a show tables button or something like that to do this but i
cant find it anywhere.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=387505

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