I am having a Sharepoint 2010 site where I'm having a List named
UserRank which has columns
User of type people & group and
After each custom email webpart an entry to this list is added.
There will hence be large number of entries in this list at the end of year for all users.
I am having another list name as
Top Users. In this list I want to show the 10 users who got highest number of entries, with distinct and count for current year.
User 1 has 200 entries, User 2 has 170 entries ....
What approach I should use here: Do I need to code in Visual Studio or can I do this by using only Sharepoint settings, or is Sharepoint Designer helpful?