4 Replies Latest reply: Jun 5, 2014 8:59 AM by Manuel Raggi RSS

    Progressive aggregate sum month by month

    Manuel Raggi

      Hi all !

      I've a problem in a pivot report, wich shows sales values, with 3 dimensions, ordered by month (4th dimension).


      I've to calculate sum of sales for current year and previous year, and the percentage variation.


      the expression for CURRENT YEAR is:


      aggr(rangesum(top(sum({<Year={$(varCurrentYear)}>}

      sales), 1, RowNo())), CLI_DES,CLI_AGE_DES, Year, Month)

       

      I need to understand why there are null values in the month with no records.

       

      I need to calculate the progressive values, for example, for CLIENTE: 3A, Month: giu = 85.992

       

      I kindly ask for your help!!