Pivot Table - Count Multiple data/records as one (unic)

[BigDeafLx]

Good afternoon

Need help ...

Suppose I have in the same base, a number of records from multiple clients (each with four entries, with 10 others, some with more) and that they bought several products from various suppliers, how can I do to make a pivot table, supplier first columml, the count of customers (only one entry)? and make the sum of those records?

Is it possible?

See the file as attachment please

Thank you

[benishiryo]

hi BigDeafLx,

u need the sum of the value uni? See if the attached is what u require. I also could not understand the comments u made beside the pivot. that it should be 2 companies & not 3 or 4. Do you need to exclude the count if Product = Nothing? Then you just have to filter the Product I included in the pivot.

[BigDeafLx]

Hello, thansk for your reply.

I need to count the real company number, not the times they appear in the database