Thread: Pivort table
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Pivort table

Hi,

1. You can copy and paste the pivot table, but then it is running from the
same cache' which may limit your grouping options and other things.
2. You can select the raw data and proceed as you did to create the first
pivot table, when asked if you want to save memory by using the same cache'
you can say yes or no depending on your needs. If you say no, both pivot
table are independent of each other.

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Kaushi" wrote:

Hi How would I get 2 pivort tables in 1 worksheet? Any help.

Thanks,
--
kaushi