Question on Report

[William08]

Hi All,

Need a help, how to get the total for each columns in reports. 

Example we have a two columns 'A' & 'B', For 'A' coulmn i need get a total by adding the each values in the row of the column A & For Column B i need to get the average as total how can we achieve this?

Thanks in advance

[Allen Andreas]

Hello,

Please review multilevel pivot tables and see if that will assist you otherwise, it will most likely not be able to be done in a standard report: https://docs.servicenow.com/csh?topicname=c_MultilevelPivotCharts.html&version=latest 

[AndersBGS]

Hi @William08 ,

As @Allen Andreas suggested, a multi-level pivot table will be your best option. But please notice, you can't have average and total in same report, hence two report is needed if possible. 

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders