Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I got the following requirement:
I should create line chart with Month as dimension
there should be 2 expressions
1. Sum(measure)
2. Sum(measure) but for each month I got find the value of the measure the month that is one year back or 12 months back
as you can see here in 2023-11 the value is 3052
while in 2022-11 the value was 2675
but the 2675 value is displayed under 2023-11
knowing that the above photo is a drawing
is it possible to accomplish this requirement using set analysis?
Hello,
You should use Month() function as dimension.
And create 2 measures.
One for CY : Year=Year(Today())
and one for LY : Year=Year(Today())-1
Regards
Antoine
but the dimension is the year-month
so under the same value of the dimension I want to display 2 values of the measure (CY and PY)
your suggestion dummy