Forum Discussion

JustasG's avatar
JustasG
Copper Contributor
Jan 22, 2024

Pivot table expands multiple rows at same time

Hi, I have created pivot table with data model since I required distinct count.
All is working well with the pivot table except when I expand rows.
 
These + signs when I press to expand it to show data what happens is instead of expanding just the one + sign that I pressed it expands multiple of them.
This is how it looks.
 
Is there some setting that is causing them to expend all together and can I change so that only the one that I press would expand.

Thanks

2 Replies

  • JustasG 

    As far as I know, you cannot change that. You're expanding or collapsing (for example) 40GP across the entire pivot table.

    • JustasG's avatar
      JustasG
      Copper Contributor
      Ok, thank you.
      It is too bad that there is no option to disable such interaction.

Resources