How to create a column report with summation column at the end.

[Milind]

Hi there,

Is there any option in ServiceNow to create a column trending report with summation column at the end?

I need to create a report with monthly trend of some data which shows count of incidents opened for every month starting from Jan, Feb, ..., up to Dec which is represented by columns. In addition to 12 columns, I want to display 13th column for sum of data of all the previous columns. So far, I have accomplished the 12 columns part and stuck for 13th column.

So if there is any way to create such report from default ServiceNow reporting functionality, please let me know. Other option for me can be to create reports using 3rd party library which I don't want to do.

Thank you.

--

Milind.

[sb1186]

Hi Milind,

Not sure if you have already tried the OOB "Aggregation" feature in the column trend report you have created.

It solves the same purpose as yours.

I have created this sample Column trending report where I have used the Aggregation on incident count basis. Along with the column chart, it would display the count of incidents opened per month in the table followed immediately after the column chart, as shown below:

Please let me know if you have already tried this and are looking for something beyond this.

Regards
Supriya Bisht

[Milind]

Hi Supriya,

Thanks for reply.

Surely your comment helped me. I done it with the way, which ServiceNow provides, and it is acceptable to us. Thank you again.

[sb1186]

Hi Milind,

Glad I could help.

Could you please mark my response to your query as Correct Answer or select YES against the Helpful option so that users looking for answers to a similar query could possibly refer to it too.

Best Regards

Supriya Bisht