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

[Anil_Babu_Samineni]

May be this?

Sum(If(Rank(Sum(FieldName))=1, Sum(FieldName)))

[sunny_talwar]

Sum within Sum won't work without Aggr()... May be this

Sum(Aggr(If(Rank(Sum(FieldName))=1, Sum(FieldName)), CodeClient, super_famille))

[Sergey_Shuklin]

Hello, Saoud!

I've generated some data with families. Please, look at the materials below, is this the task?

[Anonymous]

Hello,

Thanks for your help but it's not exactly what i want because it count only one family but it is possible that a client like a different family  : example number 000000003

thanks

[Anonymous]

Hello,

thank you for your reply, I tried your formula but it generates an error

regards

[Anil_Babu_Samineni]

Can you show the expression in image?

[Anonymous]

Hello,

image of expression

thanks

[Anonymous]

Hello,

image of expression

thanks

[Anil_Babu_Samineni]

There is no any typo error, What would be the issue. And that i've seen you image of data too. Seems working. What are you trying for right side report