Forum Discussion
Matrix Stepped Layout first column show values all rows
Anonymous ,
Have you tried creating two separate measures something like this
Location 1=calculate(<Measure Name>,Location="Location 1")
Location 2=calculate(<Measure Name>,Location="Location 2")
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Hey Anonymous,
My bad, select the location column, go on transform and click on pivot column, select value as Values column ( for you it would be Count)
Best regards,
Hi jaideepnema ,
thank you for your reply. I don't need the drill down functionality, but when I display it as a table it will not be displayed in my prefferred layout. It will display it then as followed:
Anonymous ,
Have you tried creating two separate measures something like this
Location 1=calculate(<Measure Name>,Location="Location 1")
Location 2=calculate(<Measure Name>,Location="Location 2")
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
jaideepnema wauw.. How did I not come up with this.
Thanks, it is a bit of setup work but this does the trick!