Question

Variation from Last Year Month

  • 21 February 2023
  • 5 replies
  • 148 views

Userlevel 3
Badge +9

Hello,


I want to compare Jan 23 vs Jan 22, Feb 23 vs Feb 22, etc until Dec 23 vs Dec 22 with Calculated Item but from what I see, I have to do it manually (12 times for each Month) to do it.

Is there an automatic method to do it on every months ?

Here is a picture of what I want : 

Thank you for your help :)

Alexandre


5 replies

Userlevel 6
Badge +11

Hi Alexandre,

 

To get this on all months you need to make your calculated item on another dimension. Typically use versions:
 

 

Here’s the set up:

 

Then you can put the Month in page so you only see the months you want.

Userlevel 3
Badge +9

Hello,

I don’t get it. It doesn’t seem to answer my question.

I want Var and Var in % to compare Month between Month Year-1 (not month M-1)

How can I do the Var between Jan 23 an Jan 22, etc on all months ?

Thank you

Userlevel 6
Badge +11

you can change offset 1 to 12 of course

Userlevel 3
Badge +9

Unfortunately, It doesn’t work

Userlevel 3
Badge +9

When I did it, it added “SUM” to Month here :

 

Reply