Skip to main content
Question

Variation from Last Year Month

  • February 21, 2023
  • 5 replies
  • 221 views

Forum|alt.badge.img+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

Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • February 21, 2023

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.


Forum|alt.badge.img+9
  • Author
  • Master Author
  • February 22, 2023

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


Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • February 22, 2023

you can change offset 1 to 12 of course


Forum|alt.badge.img+9
  • Author
  • Master Author
  • February 22, 2023

Unfortunately, It doesn’t work


Forum|alt.badge.img+9
  • Author
  • Master Author
  • February 22, 2023

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