Select columns when drilling into a Pivot Table

S

Smythe32

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,
 
G

Guest

You get what you get - which is all the elements.

It is showing your the underlying records/rows that make up that summary
cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table drill down sort 0
How I can set dynamic pivot table ONLY when I have enough data point 1
pivot table 1
Macro to Format the Pivot Table drill down 4
Pivot table filter list - listing irrelevant subcategorys 1
Playing back a Pivot Table macros 2
Retaining the order of Data while using Pivot table 9
VBA Pivot Table Error 1

Top