As most everyone here, i have one part with multiple suppliers. I am creating a report that has the Bin Qty but when I add in the Vendor ID, it duplicates. How can I get all Vendor ID for a specific part listed on one line? Below is what I have at this point…
group by, then use string_agg()
string_agg(VendorID, ', ')
Sorry for the question but, is this put in the calc field editor, or is there another place?
Yeah, it’s a calculated field. It’s just like Sum() or count() or any other aggregate function.