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