Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

To determine the quantity of customers who purchase two or more products, subtract the total number of unique customers from the sum of the number of customers per product. The resulting number represents the quantity of customers who purchased two or more products.

Here's the formula:

Customers who bought two or more products = Sum of customers per product - Total number of unique customers

For example, if there are 500 unique customers and the number of customers who bought Product A, B, and C are 400, 350, and 300 respectively, then the number of customers who bought two or more products would be:

Customers who bought two or more products = (400+350+300) - 500 = 1150 - 500 = 650 customers bought two or more products.