See the difference on Fact column between current year and year selected in prompt

If you want to see the differences between current year and year selected in prompt, do this:

1) You need a filter on your year column: BETWEEN YEAR(SYSTEM DATE) AND '@{year}'

This will give you the range of years for your report.

2) In your report you have three columns: Year, Revenue, and Revenue_Diff, where in the fx of Revenue_Diff you have FILTER(REVENUE_COLUMN USING (YEAR_COLUMN = 2011')) - REVENUE_COLUMN