Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to count using set analysis.
I wrote the following, but I can't get the value.
what could be wrong?
Count({<Region_ID = 3 >} Sales)
Count({<Region_ID ={3} >} Sales)
Count({<Region_ID ={3} >} Sales)
I tried that, but it doesn't work...
I wanna calculate like
If (Region_ID = 3 , count (Region_ID))
Count({<Region_ID ={3} >} Region_ID)
The expression is technically correct.
Post some data and your output.
I tried below, it works.
=count(if(Region_ID=3, Region_ID))
Thank you very much for your help!