How can you make a pivot table with only one count column?

troywheeler
Kilo Contributor

‎12-21-2017 01:35 PM

I'd like to create a pivot table that only has a column for Assignment Group and one column for the Total number of Tasks assigned to each group. It seems that ServiceNow requires to divide the columns with at least one additional field. Is there a way around that (without PA)?

Labels:
  • 1,871 Views
4 REPLIES 4

Michael Fry1
Kilo Patron

‎12-21-2017 06:55 PM

How about something like this:



Screen Shot 2017-12-21 at 9.55.18 PM.png


Preview file
147 KB
0 Helpfuls

eamoncampbell
Tera Contributor
In response to Michael Fry1

‎02-07-2018 05:45 AM

So isn't there any way then to lose the Active (or any other) field/column thereby only having Assignment Groups and totals displayed - as Troy originally enquired?


0 Helpfuls

Aditya Telideva
ServiceNow Employee
ServiceNow Employee

‎12-25-2017 08:16 PM

hI Troy,


        As a first step, Can you please group by on the service Name in a list view and see if there is any duplicate name in it? And try removing the duplicates?


0 Helpfuls

Bruno Martin2
Tera Contributor

‎09-21-2022 01:09 AM

Hi Troy,

 

Were you able to doing what you initially had requested (1 column for Assignment Group and 1 column for the Total number)?

 

Thanks,

Bruno

0 Helpfuls