Expand Single Cell In Pivot: EZ Question/HARD Answer

[HappyCamperJon]

How can I expand only 1 cell?

When I expand, all the other items of the pivot open as well. There ha
to be a simple option somewhere to just open only 1 cell right?

Because in my other file if I expand 1, it expands the objects i
thousands of other categories which causes lag as I have to open, clos
them alot. Any help would be extremely appreciated

 

[HappyCamperJon]

Very much depends on what you mean by "expand one cell"....

Sorry, youre right I should have been more clear. Here is the fil
attached.

What I meant was 1 line item. When you click the plus button to expand
it opens up all the other one in different subheadings. How can you mak
it so that you only open 1 item ONLY 1 category?

Like if I wanted to see what retailers a division in a company bought,
would expand the retailers item and it would expand, but it would als
exand for all the other divisions in the pivot table as well and tha
may sometimes make the file lag very bad. How can I just expand in onl
1 division

+-------------------------------------------------------------------
|Filename: Example Salaries at my Company.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=349
+-------------------------------------------------------------------