7 Replies Latest reply: Apr 4, 2013 12:45 PM by jagan mohan rao appala RSS

    Sum of value prior to selected date range

      Im trying to create an expression that sums up a value but for everyhting prior to the selected dates.

      For instance if I select Q1 of 2013 and get $1000 for the sum of the selection, I need to show what I got before this.

       

      I've easily gotten set analysis to work for year by year comparison, but Im stuck on this. The best I was taking all "{1} - {$}" on the date field, but that then included data that did not pertain to the selected date range, but only because it had values that feel in the all range.

       

      Does anyone have a sample?

       

      Sum({<Field_Date={" HELP ME HERE "}>} Total_Amount)