Top 5 for every group in SAP Design studio 1.6

Hi,

I have a requirement to show top 5 values for every category in design time. Source for the report is BEx.

My data looks as below:

data.png

For every sponsored prog : I have to show the top 5 sponsored class based on the key figure : Commitments and Actuals

I referred to the below blogs but this was not working in my case.

https://blogs.sap.com/2016/06/14/implement-top-nbottom-n-in-sap-design-studio-using-bial-script/

https://answers.sap.com/questions/217000/top-n-ranking-in-design-studio-by-scripting.html

Could someone please help on this?

Thanks