Forum Discussion
How to do a unique count per single item?
Dear all,
I am seeking for a solution to get a unique count for the following situation:
I have a customer table with main customer number and a an additional customer delivery number:
| Main customer number | Delivery customer number |
| 111 | 123 |
| 111 | 134 |
| 111 | 145 |
| 222 | 234 |
| 222 | 245 |
| 333 | 345 |
The final result should be a measure showing for the following main customer number the following output:
111 ---> unique count of 3 delivery customer numbers
222 ---> unique count of 2 delivery customer numbers
333---> unique count of 1 delivery customer number
Any suggestion is welcome how to fix it.
Thanks!
Hi Anonymous ,
I think you can use simply the measure COUNTROWS('Table') and put it in matrix with the Main Customer Number column in the row.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
15 Replies
- mangaus1111
Solution Sage
Hi Anonymous ,
I think you can use simply the measure COUNTROWS('Table') and put it in matrix with the Main Customer Number column in the row.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- mangaus1111
Like in this example
- mangaus1111
Hi Anonymous ,
can you send me a screenshot of your wrong result?