Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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.
Thanks Shruthi..