1 Reply Latest reply: Sep 18, 2012 6:05 AM by Johannes Sunden RSS

    Yearly Value by Historic Years Automatically

      Hi Guys,

       

      I calculate a value for spend by customers and compare against historic figures.

       

      I have a set expression for each year at the moment

       

      sum({<Year={'2012'}>}[Invoice Value])

      sum({<Year={'2011'}>}[Invoice Value])

      sum({<Year={'2010'}>}[Invoice Value])

       

      etc

       

      i would like to fix this in permanently rather than adding one each year going forward, for example using Year=(vToday)-1 , -2, -3, -4 etc for the past 5 years for example.

       

      Any ideas how to achieve this?