Line chart showing Current and Previous Year

[n1ef5ng1]

I have this line chart dimension is

1) Month

2) Year

On the expression, I have

1) sum(Sales)

I would like the line chart to show two line chart, current year (2014) and previous year (2013) without user to make any selection.

Is there anything that I can edit on the Year Dimension to show 2013 and 2014 as for this year? Current and previous year

[nizamsha]

In Dimension u can write

If(year>2012,Year)

Another Month as Dimension and expression as sum(Sales)

[nizamsha]

U can do this in another way if u like mean

Month as Dimension

write 2 expression one for current year and one for previous year

like this

Sum({$<year={"$(=Max(Year))"}>}Sales) for Current Year

Sum({$<year={"$(=Max(Year)-1)"}>}Sales)  For previous Year

[n1ef5ng1]

this will be 'hard coding' way, tedious to maintain when years to come

[#5 · Accepted solution]

HI, Benn.

=if( Year>=Year(AddYears(today(),-1)), Year)

and Suppress When Value Is Null Check, If you want.

a year later, can be sustain