Progressive aggregate sum month by month

[Anonymous]

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

[bbi_mba_76]

Hi,

could you scramble your dimensions and attach your qvw?

[Anonymous]

Ho fatto un'esempio, ecco il qvw

[bbi_mba_76 · Accepted solution]

Here an example

[Anonymous]

it works perfectly! best regards