I have a list with items that contains several columns like:
- Year
- Month
- HourCategory1
- HourCategory2
- HourCategory3
Now I want to create a table that shows only totals of the hour categories:
HourCategory1 : Sum of all items
HourCategory2 : Sum of all items
HourCategory3 : Sum of all items
Total hours : Sum of all HourCategory1 + HourCategory2 + HourCategory3
How can I achieve this with out-of-the box functionality using existing WebParts/ Views or Javascript, JSLink XSL etc.