Hi Everyone.
I createD Barchart with 2 dimensions: Managers,Ranges.
The Ranges dim include the values: Max , Min
I also have measure that calculate as following:
COUNT(IF(IsNull(RANGES)=0,IDS)/
COUNT(If(RECEIVED_B=1,IDS))
I want the denominator will ignore the dim Ranges.
I try to change the calculate as following , but it didn't work:
COUNT(IF(IsNull(RANGES)=0,IDS)/
COUNT(total<Ranges> If(RECEIVED_B=1,IDS))
Any Idea?
Thank you.