Reports Pivot Table

[ChezAndrewI0898]

Use Case:

I want to use the Pivot Table type on reports but without columns. I want only to use Row and leave column to blank or empty and only display Total in the column:

Assigned To	Total
TestUser1	15
TestUser2	25
Total	40

Is this possible?

What type of report should I use to achieve this one?

Thanks.

[Dr Atul G- LNG · Accepted solution]

Hi @ChezAndrewI0898 

we can achive like thsi

Report type= Pivot

[SidduChittaragi]

Hi Atul, 

I was implementing Incident Aging in Reports and was able to include the Aging field in the report.

However, I have a slightly different requirement. Along with Aging, I also need to display Priority and State separately in the report. Currently, when I add them, they get stacked/grouped hierarchically (Assignment Group → Priority → State) in the Pivot report.

What I’m trying to achieve is a flat structure similar to below:

Assignment Group | Priority | State | 0–3 days | 3–7 days | 7–15 days | 15–30 days | 30+ days

Instead of Priority and State getting nested/grouped under Assignment Group.

Is there a way to achieve this in ServiceNow reports?

Thanks!