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

Sort from current Month -12 until current Month

Marlene Knaup ยท

Hi all,

I would like to sort my axis from current month - 12 until current month - e.g. July-June. Is that possible?

Is is important that we can compare multiple periods (last 12 month to last 12 month previous year). The months should be next to each other.

BR / Marlene

1

Comments

2 comments
Sort by DateVotes
  • Ole Dyring

    Hi Marlene,

    I created a user dimension with 12 dynamic members: month -11, month -10, month -9 etc.

    You will need a "pure" Month dimension for this, not a hierarchy, and of course the Month dimension should be able to work with dynamic criteria.

    On the other axis I have This Year and Last Year - also dynamic.

    In this way, I can produce something like this:

    BR / Ole

    0
  • Marlene Knaup

    Thank you Ole

    0
Please sign in to leave a comment.