Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Here an example
Hi,
could you scramble your dimensions and attach your qvw?
Ho fatto un'esempio, ecco il qvw
Here an example
it works perfectly! best regards