How to show customer having more then One product in text object and pivot table

[ramrongala]

Hi Guys,

i have one query

requirement:: how many customers having more then one product(ie in screen shot Vinod and Murthy having one product so we need obey those 2 names)

Total customers =13

Based on our requirement  Total customers =11

Here is the screen shot:

I also attached QVW please help on this its  urgent merriment  

[sunny_talwar · Accepted solution]

Try this

Count({<[CUST NAME] = {"=Count(DISTINCT [PRODUCT NAME]) > 1"}>}[PRODUCT NAME])