17 Replies Latest reply: Feb 23, 2012 3:02 AM by Paul Damen RSS

    Compare to last year in table

    Paul Damen

      Hello all,

       

      I probably have a pretty simple question but I can' figure it out. I have a simple table in which I have several figures which are calculated like this:

       

      =sum({<cost_center_function = {'Sales'}> [Amount_actual] ).

       

      Which in this case gives me the sales amount. Now I want to add a column with previous year. So if I select 2012 I automatically want to see 2011 in that column the same if I select 1 month, so if I select jan 2012, I automatically want to see jan 2011 etc.

      I tried things like month-12 etc. but that doesn't work.

       

      Hope you guys can help me!

       

      Regards,

       

      Paul