Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
That never come to my mind, but it worked! Thank you!
BR,
AJ