I need to calculate, day by day, the MTD of the quantities and the distinct customers.
In the table, in the first columns, the data are daily, the others are calculated from the MTD.
For the calculation of the amount of quantities, no problem, I use the following expression:
if(rowno()<=vDAYmax, sum(if([REFERENCE YEAR]=vYEARmax ,QUANTITY)),'')
Turning to the calculation of mtd distinct customer, with the following expression, there is no result.
if(rowno()<=vDAYmax,
COUNT(DISTINCT
(if([REFERENCE YEAR]=vYEARmax,COD_ID)))
,'')
Why??
Can anyone help me ??
Thanks
Fulvio
from Italy