Having a row per Calculation

I am looking for a way to display a salesoverview per month (X-Axis) and 3 different measures (revenue, profit, profit margin) - each measure being displayed as a row for itself (Y-Axis) in one cross-tab. 

 

0

Comments

3 comments
  • Hi Jan

    Unfortunately I think the only way is to create 3 calculated rows with reference to each measure and then hide two of your measures, so that you have only one column per month.

    Let me know if you need help with the formulas etc.

    0
  • I believe the outer right button solves your problem:

    1
  • Fantastic Alexander - Thanks for the tip!

    I didn't know that button existed - That makes it a lot easier :)

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post