View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default How do I Create another pivot table, based on the first one. Thank

I have a Pivot Table with the information as follow
Account Manager Region Total Sales Total Margin
What I need is a graphic that contains only this fields
Account Manager and Total Margin
I was trying to copy the pivot table and select only the fields needed and
create the graph from here but I didn't succeed. I need as well that every
time I refresh the first pivot table the 2nd one is updated. Thank you in
advance for any help