Dear Community
I have a question with regards to a count if:
I need to count unique customer ID based on a set analysis:
Rangesum(Above(sum({<Time_Groups_Total={'Month Folder'},Sub_Category={'Drinks'}>}if(Year2Date(Trans_Month,0,if(MONTH(vMaxMonth)>11,1,MONTH(vMaxMonth)+1),vMaxMonth),$(vMeasure))/
sum(total{<Time_Groups_Total={'Month Folder'},Sub_Category={'Drinks'}>}if(Year2Date(Trans_Month,0,if(MONTH(vMaxMonth)>11,1,MONTH(vMaxMonth)+1),vMaxMonth),$(vMeasure)))), 0, rowno()))
The above should be counting customers ID where the set analysis is smaller than 80%
I have placed this set analysis in a Variable .
Please advise