How to use the dimension information on set analysis?
I need to make a table with year as dimension, and a column giving the variation from the current year on the row with the past year. I tried to use something like this: =sum({<Year={$(=Year-1)}>} Revenue) to get the revenue of the last year in the current year row, but I've received only 0's in all rows.
Follow a simple example with what I'm trying to do. The basis are two columns. One with years (2010 to 2014) and revenues. There are 10 rows for each year.
