Hi, I'd like to calculate the number of customer who has order. Besides, I want to show the the number when I select the date in the future like 30th Dec 2022. In other words, It's a accumulative value. So I write the follow function. It seems not work when I choose the future data. What 's wrong with it?
=Count( distinct if( [FY] ='CY' and FROZENDATE<=max(FROZENDATE) and aggr(sum({<FY={'CY',Month}>}ORVALUE),CustomerID)>0,CustomerID ))