Sort ( desc )list view item

Question

Hi,   I have list view where ,placed counted item formula which shows counts of item   Requirements:   document library , i want to show top 5 user;s who created document maximum i have a lookup column which stores user id ( based on user list ) .on this look up column i have applied group by which is worknig fine besides group by i want to show count of it It means it tells me who uploaded/created document most. i have also placed count item formula successfully ,   Solution Required : Based on count i want to make sorting (desc ) ,How can i do this ? Thanks

Laxmidhar Sahoo · Answer

In your sql query use with clause or rank over  clause .may solve your problem . plz display your query

ghasem sultani · Answer

hi mr. i want code or file webpart tree view for sharepoint.please

Laxmidhar Sahoo · Answer

I think there are thtree to four tables called in join like  employee,Document ,user and depertment. Their column list display .I mean the create table structure like and which field of which table you want to count Creaet table Employee ( Firstname varchar(200) . .   )

mohammad qasim · Answer

Here you go

mohammad qasim · Answer

attached is reference image  ( its view of document library )

Laxmidhar Sahoo · Answer

hi Can you display the table structure with some demo values inserted