This content has been marked as final. Show 4 replies
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!!