Hi, I have a list of a employee assigned to multiple projects.so,multiple records has created.i am trying to create a view to display the unique employee count in the list.. Can any one tell the possibility solution for this?Thanks & Regards, Sruthi

Use "Totals" option in SharePoint list view.Thanks & Regards, Neerubee

yeah ,i used it..it is taking the repeated employee for the count..it is not taking unique itemThanks & Regards, Sruthi

hello list views are based on CAML. You need some sort of DISTINCT operator for list items (e.g. distinct employee id). Unfortunately CAML doesn't have such operator, so I think it is not possible in list view as well. However it is not hard to make it programmatically. Check this link: What is the best way to retrieve distinct / unique values using SPQuery? . Hope it will help youBlog - http://sadomovalex.blogspot.com CAML via C# - http://camlex.codeplex.com Graphs visualization in Sharepoint - http://spgraphviz.codeplex.com

hello list views are based on CAML. You need some sort of DISTINCT operator for list items (e.g. distinct employee id). Unfortunately CAML doesn't have such operator, so I think it is not possible in list view as well. However it is not hard to make it programmatically. Check this link: What is the best way to retrieve distinct / unique values using SPQuery? . Hope it will help youBlog - http://sadomovalex.blogspot.com CAML via C# - http://camlex.codeplex.com Graphs visualization in Sharepoint - http://spgraphviz.codeplex.com

Hi, There is a simlar thread can help you:http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/fb5a42b9-5791-4f75-b9a0-6062b75b5e05/Xue-Mei Chang

Hi, Yeah i No,By using Totals options ,It is counting the record twice For Example: ColumnA Column B Apple Fruit Apple Fruit Strawberry Fruit Count is dipalying 3 By using Totals Option But the count is 2 since there are two fruits.While counting the list items it has not to take the repeated column records Is that possible.? Thanks & Regards, Sruthi

Did you try LINQ? E.g. var designations = from SPListItem employee in employees select new {Designation = employee["Employee Designation"].ToString().Distinct()}; Regards Prasad

Did you try LINQ? E.g. var designations = from SPListItem employee in employees select new {Designation = employee["Employee Designation"].ToString().Distinct()}; Regards Prasad

You're going to need SharePoint Designer or Content Query Webpart. SharePoint Solution Architect, Developer

To achieve this requirement you should use a query web part. There is no option available to create such kind of view in the SharePoint list. Senthilrajan Kaliyaperumal

To achieve this requirement you should use a query web part. There is no option available to create such kind of view in the SharePoint list. Senthilrajan Kaliyaperumal

To achieve this requirement you should use a query web part. There is no option available to create such kind of view in the SharePoint list. Senthilrajan Kaliyaperumal

Thanx all for your answers.Thanks & Regards, Sruthi