6 Replies Latest reply: Feb 19, 2013 9:35 AM by offtinet 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?