Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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))
Like this ?
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.
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 ?
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...