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...
| Parts | 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 |
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