Why can a List field not be the "Group By" for a report, but can be the "Additional Group By"?

Justin Abbott
Giga Guru

Fields of type List cannot be selected as the "Group By" on a bar report and I understand why. However, if you click the "Additional group by" button, fields of type List can be selected. Does anyone else see this same behavior or happen to know why? 

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

@Justin Abbott 

Hope you are doing good.

Let me know if I have answered your question.

If so, please mark appropriate response as correct & helpful so that this thread can be closed and others can be benefited by this.

If not, please let us know if you need some more assistance.

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Neha55
Tera Expert

Hi,

If If this is only a report and you are interested in the count, we can create a multi-level pivot type of report and then add it as either a Row or Column.

 

Hope that helps!