Expanding, colapsing only in one subgroup in pivot table

[geabarbic]

Hello,
I have a problem in expanding/collapsing fields in pivot table.

I have source table with GROUP, SUBGROUP, ACCOUNT and AMOUNT.
In pivot table I've put GROUP, SUBGROUP and ACCOUNT in Row labels respectivly, and AMOUNT in values.
There are same names in SUBGROUP for different names in GROUP. (for example: groups are Production costs and Distribution costs and in each of them there are subgroups Personnel costs and Other costs).

The question is:
Is it possible to expand only field Other costs in group Distribution costs while field Other costs in Production costs group stays collapsed?

Thank you very much for helping me.

Gea

 

[mcsmalls]

Bump, running into the same issue. Anybody have a solve or answer for this?

 

[mcsmalls]

Here is an update with screen shots and some direction....

--
To expand or collapse a specific item:

1. Click the Expand/Collapse button at the left of the pivot item heading
   OR, double-click on the cell with the heading.
   

Note: Collapse and Expand affect all occurrences of a pivot item. In the screen shot below, there are multiple instances of the Bars category, and they all are collapsed. You can't change collapse Bars in one Region only.

--

I want to be able to expand Bars only in the North region, without expanding Bars in the East region. When using a much larger data set it becomes hard to find the row# of what you expanding...North Bars is row 10...once I click expand and all occurrences of Bars expanding, North Bars may now be in row 942 (if there were 932 Bar values in East).
​

 

[Dryver14]

Have a look here

https://www.youtube.com/watch?v=SnmF1P_gQmM

 

[c_wag03]

I have this same frustration, but sadly although this is an old thread, it doesn't look like it got answered

 

[TheTeaTiger]

Funny how someone 10 years ago was also having the same issue.
I couldnt find a solution either, but my work around was to include an space " " in the data base so the pivot table would separate them.
So it would be:
"Bars" and "Bars "

Its not great, but it worked for me.