How do i show only the last 3 years in my Legend

[#1]

Hi Guys

I have data backing date to 1999 of subscribers (Sites) per month. I want to be able to show the financial monthly trend in a line graph only for the last three years. i.e. have 3 lines each represanting a year being shown over 12 months. Currently its showing all the years from 1999 (see picture below). Please assist.

[Gysbert_Wassenaar · Accepted solution]

You could replace your year dimension with a calculated dimension: =if(Year>year(today())-3,Year). And you'll probably want to check the option Suppress When Value Is Null for the calculated dimension.

[#3]

Thank you so much Gysbert, this is exactly what i wanted.