Forum Discussion
distinct count
Hello , I want to count how many parts with supplier more than 2 and supplier equal 1 Part Supplier W0030508752R A W0030508752R B W0030509095H-V1 A W0030509095H-V1 A W003050...
Thanks for the advice,
| Part | Supplier |
| W0030508752R | A |
| W0030508752R | B |
| W0030509095H-V1 | A |
| W0030509095H-V1 | A |
| W0030509095H-V1 | B |
| W41013044 | C |
| W41013621 | C |
| W41017168 | C |
| W41017173 | C |
| W41018408 | C |
| W41018445 | C |
I want to count how many parts with supplier more than 2 and supplier equal 1 and change with date
In this example I have the count of parts that have more than or equal 2 supplier is 5 parts and the count of parts that have one supplier is 6 parts
Your sample data does not include dates. That means we cannot comment on the requirement
I want to count how many parts with supplier more than 2 and supplier equal 1 and change with date
