Sum of RITM Variable in a report

[Burhan Shah]

Hello Community,

I am creating a report which can show the sum of all variables entered for a specific catalog item.

For example: The name of the variable is "Invoice Value" We have 5 RITMS and they have 5000 added as Invoice Value. How can I create a report showing the sum of the total Invoice Value of all RITMS?

Regards,

Burhan Shah

[Burhan Shah]

Hi @jaswalvishal106 I guess you have created a custom field in the sc_req_item table. Our scenario is different here. We don't have a custom field. The information is in the variables that can't be dot-walk in sum aggregation.

[jaswalvishal106]

My bad @Burhan Shah  as I should have read it twice before replying. I don't think so that the values can be aggregated as sum in any report type in ServiceNow. The best you can do is create a db view and then build a report out of this db (table) and display the values in a multi-level pivot table (under multidimensional reports) as shown below: