View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Smythe32@aol.com is offline
external usenet poster
 
Posts: 6
Default Select columns when drilling into a Pivot Table

Hi All,

Can this be done? I want to drill into a pivot table but only show
certain columns from the underlying data when the new sheet is created.


For instance if I have Name, Address, City, State and Zip Code as the
data in the data set. If I drill into a number in the pivot table, I
only want to see Name and City instead of all of the data elements.

Thanks,