How do we get trend from current year and current year -2 years

Ibag

Hi Gurus,

I am looking for an idea to implement. I have to show a graph of sales trend(bar grpah). When I pick a year from prompt, graph has to display the sales data of year(selected from prompt), year-1 and year-2 data.

Ex: If I pick 2016 as my year, the bar graph has to show data for 2016, 2015 and 2014.  I am unsure about deriving the attribute how to display 2016,2015 and 2014 when we select from prompt.

Thanks

[Deleted User]

If it's a numeric year you get from the prompt you can just do "Time"."Year" >= @{pvYear}{2016}-2