Report - group by and show only one record

Sandhya Karutu1
Tera Contributor

‎04-12-2017 03:07 AM

Hi

i have a requirement that i need to group by media type and show only one record for media type and include the totals with in the period. say for ex in the below all circular should be categorized and show as one record and their totals fpr each of them should sum up at the period level. say four of the records below are created at CP01 period all their total should sum up and show as one record and totals in CP01. Can some one help. I need list type report only

find_real_file.png

Preview file
38 KB
0 Helpfuls
  • 1,294 Views
1 REPLY 1

Uncle Rob
Kilo Patron

‎04-12-2017 09:12 PM

Grouping always renders a collapsible section in ServiceNow's reporting engine.   There's no way to generate "just one record" for grouping.


If that's absolutely critical, one option is to build a reporting table and a scheduled job that aggregates the totals for each Media Type on a regular interval, and stores it in that reporting record.


0 Helpfuls