Sort from current Month -12 until current Month

Marlene Knaup

June 23, 2025 12:23

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

2 comments

Ole Dyring
June 23, 2025 13:53

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
June 23, 2025 14:02

Thank you Ole

0

Please sign in to leave a comment.

New post