Expanding Single Items In Large Pivot Tables

[HappyCamperJon]

Hi,

When I Expand a category in a pivot table, it opens all of the sam
categories/types in the other subheadings as well. This causes the fil
to freeze up a bit as it is a large table. My computer is very good an
I don't have the time to group all the cells so I can drill one at
time without the others opening up.

Is there anyway I can drill only one particular item, so that not al
the same items open up?


Thanks For Your Help,

Jo

 

[Pamanabh]

Hi,

When I Expand a category in a pivot table, it opens all of the sam
categories/types in the other subheadings as well. This causes the fil
to freeze up a bit as it is a large table. My computer is very good an
I don't have the time to group all the cells so I can drill one at
time without the others opening up.

Is there anyway I can drill only one particular item, so that not al
the same items open up?


Thanks For Your Help,

Jon

Hi Jon good evening !!!!

not able to get what exactly u are looking for ...Please share some mor
details about your data