hierarchy table in excel ungroup

[#1]

Hi all

I can't ungroup tablle like it

in Qlik Sense. How can i do this?

                                  i

[ogster1974]

Using the pivot table you can expand row dimensions or set the pivot to show rows expanded as default.

[OmarBenSalem]

Can you please share a sample file to work with?

So you can see the alternative output with QlikSense?