How do I get measures on Y axis?

Frank Raijmaekers

June 02, 2021 13:58

Hi,
I would like tto have he measures on the Y-axis and the dimension (for example sales person or office) on the X-axis. Is this possible? See below.

Comments

2 comments

Louise Stub Hansen
June 02, 2021 20:11

Hi Frank

I think you need to transport it with calculated rows.

In the example below my "Medarbejderkreds" is your offices. And my "Køn" is just a random dimension.

And the 3 measures I have just renamed measure 1, 2, 3 below.

Then I create 3 calculated rows with the syntax sum(0,all,m1) and sum(0,all,m2) and sum(0,all,m3)

And then I hide 2 of the measures and the "random" dimension "Køn". (Some how if I haven't got a dimension in the left side, I can't create a calculated row).

And I can e.g. then rename "Measure 1" to " ":

I hope this can be a solution to your question?

1
Danilo Rufino
June 10, 2021 15:56

I also use this method, Louise!

1

Please sign in to leave a comment.

Didn't find what you were looking for?

New post