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

Set Analysis: all previous years untill selected month

offtinet

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?