Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Same as below link.
I want to create a line Chart only Show Q1 = Mar2023 Q2 = Jun2023, Q3 =Sep2023, Q4 = Dec2023 just like below
By using
Dimension:
Dual('Q'&Num(Ceil(Num(Month(InvDate))/3)),Num(Ceil(NUM(Month(InvDate))/3),00))
Measure:
Sum({<InvId = {'=Month(InvDate)=Month(QuarterEnd(InvDate))'}>}Sales)
OR
Sum(If(Month(InvDate)=Month(QuarterEnd(InvDate)),Sales,0)).
However The Line Chart sum with all the year. I want the Line chart have two line
Current Year , Last Year. like below picture
how should i revise the measure.
Can anyone help?
Hi ,
Create two different measures for Current year and previous year and add them in measures .
SUM({$<Year={'$(=Year(Today()))'}>} Sales) // sales for current Year
SUM({$<Year={'$(=Year(Today())-1)'}>} Sales) // sales for previous Year