Good day everyone,
have been searching for this in many old discussions, but well here is my problem.
I am making a chart where in the rows are the values of some products selected. and each column has a date like this:
01/2013 - 02/2013 - 03/2013
value - value - value
This values are the total of the month and the prevous eleven ones.
Like this:
01/2013: 01/2013+12/2012+11/2012+10/2012+09/2012+08/2012+07/2012+06/2012+05/2012+04/2012+03/2012+02/2012
02/2013: 02/2013+01/2013+12/2012+11/2012+10/2012+09/2012+08/2012+07/2012+06/2012+05/2012+04/2012+03/2012
03/2013: 03/2013+02/2013+01/2013+12/2012+11/2012+10/2012+09/2012+08/2012+07/2012+06/2012+05/2012+04/2012
Here is an expression i was making by all the discussions i read.
= sum({<Date={">=$(max(prev_Date))<=$(max(Date))"}> } Value)
where
Date: field of the selected date or last date of the value in the certain case.
prev_Date: field of the date 11 month earlier
value: the value wanted from each date sum up
Date: 03/2013
prev_Date: 04/2012
Please help.
