Pivot Table

T

tkaplan

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

CyberTaz

Hi tk-

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

HTH |:>)
 
T

tkaplan

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

Debra Dalgleish

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.
Click to expand...
 
Top