6 Replies Latest reply: Feb 19, 2013 9:35 AM by tine theunis RSS

    Set Analysis: all previous years untill selected month

      I want to select a year and a month and I want to see:

      - all amounts including the full previous years untill the selected month and year. For example full 2010, full 2011, full 2012, jan 2013 and feb 2013

      - all amounts untill selected month year -1. For example  full 2010, full 2011, jan 2012 and feb 2012


      I have tried:


      sum({$<Year = {"<=$(=max(Year))"},     Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"},>}TOTAL Amount))


      But this obviously only gives me the amounts of january and february for all the years.

      Any ideas?