I have a list which displays the leave history of the users in a department.
Now, I want to consolidate the data in this list in such a way that I want to calculate the total number of leaves availed by each user.
For example, a user has availed leaves(any number of days) on 5 different occasions, I want to add the total no. of leave days for these 5 occasions and display as one item against the user name.
Users name is "people and groups" column type and the leave is a "calculated column" type
I couldnt find a way to display this data.
Any suggestions or help would be greatly appreciatted.