Count after a distinct

[#1]

Hello everyone,

I'm trying to count a section after distinguishing another section. Here is what I'm trying to achieve (but obviously doesn't work) :

Distinct(ID_Company) then Count(Status_Company)

How can I manage to accomplish that.

Thanks in advance !

Alex

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(Count(DISTINCT Status_Company), ID_Company))

[#3]

Seems to be working.

Thank you!