

- 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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, maybe with:
Count(DISTINCT {<[invoice no]={"=Count({1}Distinct [item category code])=1"}>} [invoice no])


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear ,
thanks for your response
i will apply the code and get back to you.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])
