

- 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
Hello Tripati, you created 2 duplicates of this thread. Can you delete them and keep one please.
Thanks,
v.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
first thing to get the distinct count
COUNT(Distinct [Invoice No])
Then you can ether add filters to the front end to filter the value or build up your set analysis like
COUNT({<itemcategorycode ={'proease'}>}Distinct [Invoice No])
Mark


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add item category code as your Dimension and expr as below:
= Count(DISTINCT [invoice no])
Using straight table chart.
