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:


      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!!