Help Needed with Incident Aging Pivot Report Structure

SidduChittaragi
Tera Contributor

Hi Community,

I tried implementing Incident Aging 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 as shown below.
SS1.png

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 - Please Refer below SS
SS2.png

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

Is there a way to achieve this in ServiceNow reports?

Thanks!

0 REPLIES 0