Any alternative to RANK function in DWC

[former_member89645]

Dear Colleagues,

I have a table in DWC as below

Sample CSV attached.

I need to find out sum of amount for top 2 Suppliers for each category. The desired output is as below

I don't see any way of doing this is graphical view. Can it be done in SQL view? I tried using rank function but looks like rank is not supported in DWC quite yet. Refer this help link Not all HANA SQL functions are supported in DWC.

Any help to accomplish this in DWC or even in SAC is really appreciated.

Thanks!

supplier-rank-datacsv.txt

[former_member89645]

Sven, That worked! thank you so much.

[j_vandersterren]

Hi Rajesh,

Could you please share your solution?

Regards,

Jos.