Multi-Level Pivot Table with Count as the Only Column

KStaf
Tera Contributor

Hello,

 

I want to create a report with multiple rows (two variables) and Count as the single column, like this:

KStaf_1-1722587149629.png

 

I have already implemented the workaround described in the discussion below (create a multi-level pivot table and add the active field as the column): https://www.servicenow.com/community/platform-analytics-forum/possible-multi-level-pivot-tables-w-no...
But I'm still wondering if there is a way to avoid having both columns (active, count) which display the same information.

1 REPLY 1

HIROSHI SATOH
Mega Sage

Unfortunately, you cannot delete the count column. I think the only workaround is to make a matrix with variable 1 and variable 2, or to set a field with business value to the column.