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])




      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?