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...
your sample data is insufficient to cover your scenarios.
| Material | Posting Date | Suppliers |
| W8TC1806100C | 05-01-2020 | A |
| W43002256AC | 08-01-2020 | B |
| W63X54HL | 08-01-2020 | B |
| W41018395 | 12-01-2020 | E |
| W43011994S | 12-01-2020 | E |
| W43016101S | 12-01-2020 | E |
| W91104433S | 12-01-2020 | E |
| W43002256 | 14-01-2020 | B |
| W43002256AC | 14-01-2020 | B |
| W41018395 | 14-01-2020 | E |
| W43011994S | 14-01-2020 | E |
| W43016101S | 14-01-2020 | E |
| W91104433S | 14-01-2020 | E |
| W41018395 | 18-01-2020 | E |
| W43011994S | 18-01-2020 | E |
| W43016101S | 18-01-2020 | E |
| W91104433S | 18-01-2020 | E |
| W430117AC3S | 20-01-2020 | D |
| W430117C3S | 20-01-2020 | D |
| W430117DC3S | 20-01-2020 | D |
| W430317AC3S | 20-01-2020 | D |
| W430317C3S | 20-01-2020 | D |
| W430317DC3S | 20-01-2020 | D |
| W430517C3 | 20-01-2020 | D |
| WC7S100X75 | 20-01-2020 | D |
| WH7S100X75 | 20-01-2020 | D |
| WH8S100X75 | 20-01-2020 | D |
| W43000493 | 20-01-2020 | G |
| W43000505 | 20-01-2020 | G |
| W8TC1806100C | 21-01-2020 | A |
| W41018395 | 21-01-2020 | E |
| W43011994S | 21-01-2020 | E |
| W43016101S | 21-01-2020 | E |
| W91104433S | 21-01-2020 | E |
| W41018395 | 23-01-2020 | E |
| W43011994S | 23-01-2020 | E |
| W43016101S | 23-01-2020 | E |
| W91104433S | 23-01-2020 | E |
| W0030509095H | 25-01-2020 | B |
| W41018395 | 26-01-2020 | E |
| W43011994S | 26-01-2020 | E |
| W43016101S | 26-01-2020 | E |
| W91104433S | 26-01-2020 | E |
| W43000493 | 26-01-2020 | G |
| W0030509095H | 28-01-2020 | B |
| W63280Z12DNE | 28-01-2020 | B |
| W63X54HL | 28-01-2020 | B |
| W43002256 | 30-01-2020 | B |
| W43002256AC | 30-01-2020 | B |
| W43000493 | 30-01-2020 | G |
| W43000493 | 03-02-2020 | G |
| W43002256 | 04-02-2020 | B |
| W430117AC3S | 04-02-2020 | D |
| W430117C3S | 04-02-2020 | D |
| W430117DC3S | 04-02-2020 | D |
| W430317C3S | 04-02-2020 | D |
| W430317DC3S | 04-02-2020 | D |
| W43000493 | 06-02-2020 | G |
| W43000493 | 06-02-2020 | G |
| W0030508752R | 07-02-2020 | B |
| W63280Z07DNE | 07-02-2020 | B |
| W63280Z10DNE | 07-02-2020 | B |
| W41018395 | 10-02-2020 | E |
| W43011994S | 10-02-2020 | E |
| W43016101S | 10-02-2020 | E |
| W91104433S | 10-02-2020 | E |
| 41043465H | 10-02-2020 | H |
| W20180227 | 10-02-2020 | H |
| W21448072 | 10-02-2020 | H |
| W41008862 | 10-02-2020 | H |
| W41013621 | 10-02-2020 | H |
| W41013814 | 10-02-2020 | H |
| W41017168 | 10-02-2020 | H |
| W41017173 | 10-02-2020 | H |
| W41018408 | 10-02-2020 | H |
| W41018445 | 10-02-2020 | H |
| W41019104 | 10-02-2020 | H |
| W41021016 | 10-02-2020 | H |
| W41021255 | 10-02-2020 | H |
| W41021741 | 10-02-2020 | H |
| W41021829 | 10-02-2020 | H |
| W41021881 | 10-02-2020 | H |
| W41021976 | 10-02-2020 | H |
| W41021980 | 10-02-2020 | H |
| W41022049 | 10-02-2020 | H |
| W41022300 | 10-02-2020 | H |
| W41023685 | 10-02-2020 | H |
| W41024476 | 10-02-2020 | H |
| W41026473 | 10-02-2020 | H |
| W41027093 | 10-02-2020 | H |
| W41033254 | 10-02-2020 | H |
| W41034869 | 10-02-2020 | H |
| W41036197 | 10-02-2020 | H |
| W41037571 | 10-02-2020 | H |
| W41038265 | 10-02-2020 | H |
| W41039460 | 10-02-2020 | H |
| W41040031 | 10-02-2020 | H |
| W41040283 | 10-02-2020 | H |
| W41040979 | 10-02-2020 | H |
| W41040994 | 10-02-2020 | H |
| W41041005 | 10-02-2020 | H |
| W41041367 | 10-02-2020 | H |
| W41041369 | 10-02-2020 | H |
| W41041380 | 10-02-2020 | H |
| W41041381 | 10-02-2020 | H |
| W41041608 | 10-02-2020 | H |
| W41042533 | 10-02-2020 | H |
| W41042893 | 10-02-2020 | H |
| W41042927 | 10-02-2020 | H |
| W41043962 | 10-02-2020 | H |
| W41044550 | 10-02-2020 | H |
| W41045967 | 10-02-2020 | H |
| W41048221 | 10-02-2020 | H |
| W41048222 | 10-02-2020 | H |
| W43000134 | 10-02-2020 | H |
| W43005378 | 10-02-2020 | H |
| W43005963 | 10-02-2020 | H |
| W43008783 | 10-02-2020 | H |
| W43010381 | 10-02-2020 | H |
| W43010993 | 10-02-2020 | H |
| W43012569 | 10-02-2020 | H |
| W43017575 | 10-02-2020 | H |
| W43020080 | 10-02-2020 | H |
| W43020091 | 10-02-2020 | H |
| W43023852 | 10-02-2020 | H |
| W43025155 | 10-02-2020 | H |
| W46006726 | 10-02-2020 | H |
| W90319302 | 10-02-2020 | H |
| W90467903 | 10-02-2020 | H |
| W91200193 | 10-02-2020 | H |
| W91400204 | 10-02-2020 | H |
| W91408004 | 10-02-2020 | H |
| W91408008 | 10-02-2020 | H |
| W91602887 | 10-02-2020 | H |
| W91602948 | 10-02-2020 | H |
| W92250869 | 10-02-2020 | H |
| W92412188 | 10-02-2020 | H |