Need help in logic

[tripatirao]

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