Expand a single row

Copper Contributor

Hello everyone !


I need to validate something with you.


In a pivot table, I have the same row in multiple sections (e.g : a product 1 in 5 different stores). I would like to expand the row for product 1 in store 1 without expanding the rows for product 1 in the other 4 stores.


In my case, when I expand product 1 in store 1, it also expands product 1 in the other stores.


Is it possible ?


Thank you

2 Replies


It depends on how your PivotTable is built. Something like this?


It's the opposite. Using your example, I would like to be able to expand store B in the product 1 section without expanding store B in the product 3 section.