Hi

I would like to to collapse child group by rows when Parent Group by row collapse.

Attached zip file has the code and image (result that I am expecting) file.

1. Run the code,

2. Group by "Abbreviation" and "IDName"

3. Collapse first Groupby row (i.e. empty abbreviation)

4. This will show two child group by rows with N1 and N2.

5. Expand N1 and N2 group by rows

6. Collapse Parent i.e. Abbreviation group by row (keeping N1 and N2 group by rows expanded)

7. Expand the parent i.e. Abbreviation group by row.

8. N1 and N2 shows with expand (as they were expanded before).

How to make N1 and N2 collapsed when parent row collapsed?. This should work for any level of group by rows.

Can you modify the code and upload back.