Count Distinct clients by rank

[Anonymous]

Hello,

I would like to get a count distinct customer based on the rank of the family, only where the rank= 1. The objective is to obtain a histogram counting the distinct clients according to the preferred family

thanks you

[sunny_talwar]

What sort of error does it display? can you share the error message or a snapshot of the error message?

[Anonymous]

On the right report I would like it also counts clients rank equal 1 on other families as the "KITCHEN"

regards

[Anonymous]

hello,

here is the error

thanks

[sunny_talwar]

You are using this as a dimension? What is the final output you are looking to get? I thought that this was an expression....

[Anonymous]

no sorry

I am looking to get a discount from customers on preferred families

thanks

[Anil_Babu_Samineni]

I assume, You require nested aggregation over here, Would it possible to share sample application

[sunny_talwar]

What would be the output in a table form that you want to see? What are the dimensions?

[Anonymous]

here is table, I would like  this report

!

thanks

[Anonymous]

an example

Thanks

[Anil_Babu_Samineni]

I opened your machine, You are calculating only for first rank, That is how it return only for that

And, i used this? and i got it as below

If(Rank(Sum(DISTINCT customer_code))<=4, Sum(DISTINCT customer_code))