One column has thousands of materials list [codes & descriptions] and in other column has corresponding supplier name and lastly third column has purchase value. Here one material could be supplied by single or multiple suppliers.
How to derive one material is supplied by how many suppliers and their corresponding value. pls help.
How to derive one material is supplied by how many suppliers and their corresponding value. pls help.