Alternate State Issue

[Anonymous]

Hi,

Need your help.

I have the following table:

Karthick	Muthu	CAR	100
Veni	Thangam	TV	200
Sudheep	Suthan	TOY	300
Anand	Muthu	SHOE	400
Suriya	Thangam	CAR	500
Ganesh	Suthan	TV	600
Karthick	Muthu	TOY	700
Veni	Thangam	SHOE	800
Sudheep	Suthan	CAR	900
Anand	Muthu	TV	1000
Suriya	Thangam	TOY	1100
Ganesh	Suthan	SHOE	1200

Also, i have the following expression:

=sum( {$<Customer = P({<Product={'CAR'}>}Supplier)>}Sales). But I am getting a value of zero for this. Why I am getting zero for this?

My expectation is 7800 (because CAR is associated with Three Suppliers (Muthu,Thangam and Suthan and those suppliers are associated to all the Customers)

Thanks,

Karthick S

[sunny_talwar]

Apologize for overlooking your solution. I didn't realize that you have already provided the same solution.