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 :
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.