Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
tripatirao
Creator II

Need help in logic

Dear All,

I want to know the count of distinct invoice no based on the selection of item category code.

for  exemple in the data set

i want output as below

itemcategorycode  no. of invoice

proease,2

because in  invoice no (900012346,900020000) only proease item sold .

Similarly for itemcategorycode uniwash, no of distinct invoice 1(900012347),

and for itemcategorycode xpert no of distinct invoice 1(900012348)

Please find the attached excel file and do the needful.

Regards

RTR

4 Replies
rubenmarin

Hi, maybe with:

Count(DISTINCT {<[invoice no]={"=Count({1}Distinct [item category code])=1"}>} [invoice no])

tripatirao
Creator II
Author

Dear ,

thanks for your response

i will apply the code and get back to you.

tripatirao
Creator II
Author

Dear,

Your code is worked for me.

Can you please help me on the below requirement.

I need to show no of invoice for the combination of item category code.

please find the attached excel

rubenmarin

Hi Tripati, maybe you can create a table with a calculated dimension:

=Aggr(Concat(DISTINCT [item category code],'+'), [invoice no])

And the expression:

Count(DISTINCT [invoice no])