I have a calendar that I'm using to track employee sick time. I have two fields from which I'm trying to create a new list view. "Employee Name" is a Person or Group field and "Occurrences" is a number field.

I'm trying to create a list view that will only show 1 row for each employee and provide the sum of the Occurrences in the cell next to the employee's name.

I've tried using the Group By setting in the list settings, but this does not give me the truly desire result. Any other thoughts?

1 Answer 1


You could try the Totals setting in the list view settings.

  1. In Group By section, Group By the column "Employee Name".

enter image description here

  1. In Totals section, choose sum for column "Occurrences". enter image description here

The view would be like this:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.