I have had a request to create a report to pull through how many of our customers have usage data for a specific product (not all are on a version that support sending usage data to PX)

I used the “PX Person Information” field as that was the only way I could find to pull the “Name” (company name) and the product name (so that I could then filter this on the specific product I wanted to pull.

However when I filter this down to just a specific product and run this report, the company names are appearing loads of times. For example, for one company they have about 28 rows in the report, whereas I just want them to appear once.

Anyone have any idea what I have done wrong?