Expand a single row

[Jacktah]

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]

@Jacktah 

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

[#3]

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.