top 10 file no and transaction date based on amount along with name in straight table

[#1]

Hi all,

I need help in my current assigment where i want to achieve result in a straight table like ....

I need top 10 applicant name based on their amount (disbursement/debt balance) along with file no and Date (on which date this amount was disbursed in this file no). Date field is must in staright table .

Date and file no is must..........

Please find out the qvw doccument attached for your understanding and reference..........

Its very urgent......

Thanx in Advance...

Regards,

Dushyant

[#2]

u can see in straight table repeated values are coming .........that should not happen when we are looking for top ten result????????

[vgutkovsky]

I think you might be a little confused as to what "top-10" means. Top-10 does not mean that you will see 10 rows in a table, but rather only 10 unique customers.