1. TARGIT Community
  2. Community
  3. Frontend, Designer and Consumer
Knowledge Base

Having a row per Calculation

Jan Eriksen ·

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
Sort by DateVotes
  • Louise Stub Hansen

    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
  • Alexander Strøm

    I believe the outer right button solves your problem:

    1
  • Louise Stub Hansen

    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.