Top Vendor Name from City

[#1]

Dear All,

i want to get Citywise TOP Vendor name which i want to display on Table. i have written a set analysis as below. kindly check and let me know what wrong is there.

1.) getting the citywise, max vendor T/O information.

2.) getting the name of the Vendor from that max value.

=Only( {$<VENDORSHORTNAME={"=(sum( TRADE_VALUE)/vmaxDay))=MAX(AGGR((sum( TRADE_VALUE)/vmaxDay),CITY,VENDORSHORTNAME))"}>} VENDORSHORTNAME)

Thanks & Regards,

Jitendra

[anbu1984 · Accepted solution]

Try FirstSortedValue(Vendor,-Aggr(Sum(Sales),Vendor,City))

[#3]

by below mention syntax i am able to get top turnover

=MAX(AGGR((sum( TRADE_VALUE)),CITY,VENDORSHORTNAME))

Now i want to get the VENDORSHORTNAME from this. means what is the VENDORSHORTNAME of that max turnover

[#4]

Thanks Anbu Cheliyan