Sort ( desc )list view item

mohammad qasim

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
In your sql query use with clause or rank over clause .may solve your problem .
plz display your query
0
ghasem sultani6y ago
hi mr.
i want code or file webpart tree view for sharepoint.please
0
Laxmidhar Sahoo6y ago
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)
.
.

)
0
mohammad qasim6y ago
Here you go

0
mohammad qasim6y ago
attached is reference image ( its view of document library )

0
Laxmidhar Sahoo6y ago
hi
Can you display the table structure with some demo values inserted
0