how to add multiple columns in single Report?

Anurudh Kumar · ‎02-02-2022

Hi Experts,

In a table there is three columns Containing integer value, while creating a report or dashboard I want to show all three columns SUM in a single Bar or list. Please guide.

Eg. C1=2,C2=3,C3=5

IN report or Dashboard, I want SUM OF C1,C2,C3 that is 8

Voona Rohila · ‎02-02-2022

Hi Anuradh

You can use Aggregation sum on each field and use data table to view the total

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
5x ServiceNow MVP

Community Alums · ‎02-13-2022

Hi Anurudh,

Please use function fields to achieve this. Here is a video to help this.

Please mark this comment as Correct Answer/helpful if it helped you.

Cheers,

Hardit Singh

Connect with me on YouTube