2 Replies Latest reply on May 28, 2013 10:51 PM by Ajit Kumar

    Privous Year Number

    Ajit Kumar

      Hi,

       

      I want to see all the measures on Yearly basis. So I have created a table where I have put all the measures and Year in the filter.

       

      In the last row we have Profit there for 2009. The twist is I have to see Profit for previous year. I mean to say once I select 2010 then I
      should see profit of 2009, when I select 2011 then I should see profit of 2010 and so on.

       

      Is it possible to achieve the above in the same table or do I need to create a different sheet for this?

       

      Ajit