2 Replies Latest reply: May 21, 2014 3:02 PM by Eduardo Pinhata RSS

    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.

       

      Thanks