RANGE FILTERS

[Wayne_101]

Hi

[Wayne_101]

@Saryk 

it works perfectly fine , just one last thing how can i make it work with count(distinct customer_id)

what you suggested for dimension

=if(
(MO >= $(vMinMO) and MO <= $(vMaxMO)) and
(RC >= $(vMinRC) AND RC <= $(vMaxRC))
,CUSTOMER_ID)

what you suggested for Measure

=if(Aggr(sum(RC)>= $(vMinRC), CUSTOMER_ID) and Aggr(sum(RC) <= $(vMaxRC),CUSTOMER_ID),sum(RC))

logic i want to use for dimension :

=if(
(MO >= $(vMinMO) and MO <= $(vMaxMO)) and
(RC >= $(vMinRC) AND RC <= $(vMaxRC))
,count(distinct CUSTOMER_ID))

[Saryk]

Like this ?

[Wayne_101]

@Saryk 

no,like this in table not in kpi card... but i don't wish to see one row i want to see no of customer which fall in my ranges.

[Saryk]

I'm sorry but I don't see what you expect. Either you have a table with the detail of the customers id, or you have a one row count. 
What would your multiple rows contain ?

[Saryk]

Perhaps something like this, where the count appears in the TOTAL cells at the top of the table ? This implies having a column of 1s though...