put before 12 months on a Selected Date from calendar in X-Axis
I have a doubt:
I ned to calulated a progress on a Date that user select by Calendar(i associate it to a a Variable vCUTOFFDATE).To calculate a progress on a Data i put in expression "=sum(if(DATEPROGRESS <=vCUTOFFDATE,PROGRESSPERC,0))"
The problem is that the client ask if it's posible to calculate a PROGRESS on 12 month before and put the progress caluclation in a Line chart.
so, if for example the user selected 12-12-2012 on the x axis shoulb be