Member wise top Vendor List

[#1]

Hi , i have a table which have Member, Vendor wise Orders information like Below:

Date	MemberId	VendorId	Orders
1/1/2014	10	A	100
1/1/2014	10	B	200
2/1/2014	20	A	100
2/1/2014	10	C	300
2/1/2014	30	C	100
2/2/2014	20	B	400
2/3/2014	30	A	200

i want to know memberwise top Vendor like :

MemberId	Top Vendor
10	C
20	B
30	A

[#2 · Accepted solution]

you can create a straight table, with memberid and vendorid in dimensions. add expression sum(orders).

In dimension limits select Vendorid and select larget 1 in the dimension value.

you will get top vendors listed for each memberid.

[#3]

Thanks Shruthi..