Only customer with multiple product?

[#1]

I have data that looks like:

Customer	Product
Frank	Ball
Sam	Bat
Charlie	Ball
Frank	Glove
Dan	Bat
Sam	Ball
Frank	Bat

I would like to show only those customers who have more than 1 product.  In this case I would like to have a table that show only Frank and Sam and the products they have purchased.  Something like:

Frank     Ball

             Glove

             Bat

Sam     Bat

            Ball

This is probably something very simple but I am missing it.

[swuehl · Accepted solution]

Maybe like attached?

[jagan]

Hi STeve,

Use Customer and Product as Dimensions and use the below expression

=Count(TOTAL <Customer> Distinct Product)

HOpe this helps you.

Regards,

Jagan.

[#4]

Awesome!  Thanks for your help.  This works just like I wanted it.