TOP 5 in the Table

[Anonymous]

Hi Friends,

Need your help here.  I have 3 columns (Party Name, Ratings, Amt). I have to find the Top 5 Party Name on the basis of Amt.

The challenge here for me is that there are multiple Ratings for the Party Name(so there are multiple lines and the corresponding Amt) , but i need to show only the highest rating for the party in the table, but the sum of Amount would be the Sum of the Amt not only that particular Rating.

I have attached the Data in the excel and even attached the OUTPUT in the same Sheet. 

Please let me know if this is not understandable..

Require your help...

Thanks

Ankit Modi

[MK_QSL]

Hi Ankit,

Have your tried my solution?

[Anonymous]

HI Manish,

ya when i am using in my Actual application its not working.

[MK_QSL]

Check enclosed file...

[#5]

Hi Ankit,

   PFA

[Anonymous]

Thanks Manish

[Anonymous]

Thanks Mukesh.. One last Question how you restricted Top 5 in your application?

[MK_QSL]

If you get your solution... kindly close the thread by selecting the correct/helpful answer

[#9]

Hi,

Table Properties --> Presentation --> Max Number --> only top 5(Sorting on Amount in Sort tab also)