Expanding Single Items In Large Pivot Tables

H

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
 
P

Pamanabh

HappyCamperJon;1601223 said:
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
Click to expand...


Hi Jon good evening !!!!

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