how to add multiple columns in single Report?

Anurudh Kumar
Mega Expert

‎02-02-2022 07:18 AM

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 

0 Helpfuls
  • 2,321 Views
2 REPLIES 2

Voona Rohila
Kilo Patron
Kilo Patron

‎02-02-2022 07:51 AM

Hi Anuradh

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

find_real_file.png


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
2022-25 ServiceNow Community MVP
Preview file
15 KB
0 Helpfuls

Community Alums
Not applicable

‎02-13-2022 01:41 AM

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

0 Helpfuls