Distinct Data

[Sameer9585]

Hi,

I have a data as the file below in it sheet 3 now I need have the output as Sheet 4.

I need the output as distinct data and formula for KPI of count of distinct bills.

Thanking you in advance,

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT {<ID = {"=Count(Product) = 1"}>}  ID)

[Sameer9585]

I have tried this aggr(if(Count({<Product=>}Bill)=1,Bill),Bill) it works but I need it in an efficient way.

Is there any alternative?

[sunny_talwar]

Did you just ignore my response above? 🙂

[Sameer9585]

No,I accept it and tried it but I require in any efficient way like any other alternative

[sunny_talwar]

This doesn't look efficient to you?

Count(DISTINCT {<ID = {"=Count(Product) = 1"}>}  ID)

What is wrong? 

[Sameer9585]

That works fine.

[sunny_talwar]

Now it works? Are you sure you are happy with the performance? I am more than happy to work if you can elaborate on the issue you are facing

[Sameer9585]

Can you help in creating the dimension for the same problem? Without aggr() please

[sunny_talwar]

What exactly do you mean?