Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a chart showing the number of unique customers that have placed an order by month, since the year start. I'm doing:
RangeSum(Above(Count(DISTINCT idClient), 0, RowNo(TOTAL)))but if a customer has placed orders both e.g. in Jan and Feb, it is counted twice, while it should be counted only once, in the first order month. I need to preserve filtering and drill-down, so I cannot create a column in the script.
Any suggestions?
Many thanks,
Hello, maybe this can help you :
Hello, maybe this can help you :
perfect, thanks!