Multi-Level Pivot Table with Count as the Only Column
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2024 02:18 AM
Hello,
I want to create a report with multiple rows (two variables) and Count as the single column, like this:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2024 03:08 AM
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.