Pivot table row names and set analysis

[AJM]

Hi,

I have a pivot table which has year dimension as a column. I also have one row of values (growth), it has been calculated via set analysis. The outcome is:

                              2017          2018          2019
                             growth     growth     growth
empty                *value*     *value*     *value*

When I want it to be:

                    2017          2018          2019
growth    *value*     *value*     *value*

I can hide the growth header, but even if I drop the growth header out, on the left is still the empty space. I would like to have the text "growth" on the empty space. Is there a way via set analysis to give a "name" to my set analysis calculation so that would show on the empty space on the left? That way I could hide the growth header and it would be just fine. Or is it possible to somehow to move the header on the left and hide the empty space? I hope that someones understands what I am trying to explain. Thank You!

BR,

AJ

[Gysbert_Wassenaar · Accepted solution]

Try adding a row dimension with 'growth' as expression and growth as label.

[AJM]

That never come to my mind, but it worked! Thank you!

BR,
AJ