

Creator II
2018-10-31
12:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
360 Views
0 Replies
