Find my approach
In the attached workbook if you pick any one of the product you'll get relative customer names who made sales on that particular product.I did this on superstore data if you provide me your data i'll do it on the data set.
Mark my answer helpful if it's helpful for you.
Filter on a profile.twbx 1.2 MB
Hey Godi duppati, could you upload the workbook?