Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks
try Below(sum(Revenue),1)
It worked! Thanks!