Skip to main content

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

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.

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

you can change offset 1 to 12 of course

Unfortunately, It doesn’t work

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

 

Reply


Ask your question here!

Terms & ConditionsCookie settings