Summing columns in a report

[Will Schaffran]

I'm creating a report using the Time Card table to replicate one of our reports from another system (picture below). The grouping is on the user (I marked out names in red), and we report how much time they spent on each project (marked out in black). Time range will be dynamic so we can report a user's total hours for weeks, months, or whatever time range is selected. I need to be able to sum the column results per user, which you can see at the bottom of the picture. How do I do this in a list report? Do I need to create a pivot table?

  

[Alberto Consonn]

Hi,

you should use the Performance Analytics by setting up two indicators and using a list scorecard.

Check the official documentation below:

https://docs.servicenow.com/bundle/newyork-performance-analytics-and-reporting/page/use/performance-...

If I have answered your question, please mark my response as correct and/or helpful.

Thank you very much

Cheers
Alberto

[Community Alums]

Pivot or multi-level pivot should be fine.

[Will Schaffran]

The problem with pivots is that they don't allow for multiple columns. We need columns for every day of the week, and the last column is the total. On each row (marked out in black) is a project the user has worked on. Is there a way to get pivots to do that?

[Adam Stout · Accepted solution]

If a list doesn't cut it for you, you may want to look at a custom UI page to give exactly what you want. 

Generally, this is discouraged as it is custom and often the same business objects can be met with OOTB functionality.  However, if it has to look like this, that may be the way to go.