Help center Reporting and performance Group cases and use table pivoting to find work that needs attention Updated Wednesday, October 28, 2026 · Marcel Gravelle Case-list grouping collects records with the same field value into sections so you can inspect patterns without reading one long flat list. Use it to review work by Company, owner, status or another supported grouping field. In a B2B operation, this can make it easier to spot a customer with several waiting cases or an uneven distribution of work, then open the individual records that require a decision.At a glanceFor: agents, queue owners, supervisors and account managers reviewing case lists. Applies to: Supportbench Core.Start here: Cases → Case list options → Options → Grouping bar and table pivotingDistinguish grouping, filtering, sorting and reporting · Choose the result before choosing the groups · Enable the grouping bar and group the current list · Choose a personal default grouping · Use grouping for real support decisions · Example: several cases for one customer are waiting · Troubleshoot missing or confusing groupsDistinguish grouping, filtering, sorting and reportingActionQuestion it answersExampleFilterWhich eligible records should be included?Open cases for the relevant customer or queue.GroupWhich included records share a value?Collect the matching records by Company, then inspect the relevant group.SortIn what order should the included records appear?Put a relevant deadline or creation order first where supported.Calculate a metricWhat measure is defined for a particular population and period?Use the KPI or Dashboard definition for an agreed service measure.ExportWhat did this result contain when the file was generated?Create a dated agenda for an account review.The UI calls the feature “Grouping bar and table pivoting” because it supports a spreadsheet-like way to organize the grid. It does not promise an unrestricted spreadsheet pivot engine with arbitrary calculated measures or every possible system field. Some columns explicitly do not support grouping.Choose the result before choosing the groupsOpen the relevant Cases view and confirm Agent, Queue and any active filters. Grouping starts from this result; it does not search the whole account independently.Choose the operational question. “Which customers have several cases waiting for our next action?” needs different inclusion criteria from “How much work is closed this month?”Check that the field values are maintained consistently. Missing or inconsistent Company, issue or owner information can produce misleading groups.Find a known case that should appear and one that should not. Confirm the view’s result before adding presentation complexity.Choose one useful first grouping. Add a second only when it helps a specific decision. A case-ID group with one case per group often adds clutter rather than insight.Enable the grouping bar and group the current listOpen Cases.Choose the gear labelled Case list options.On Options, turn on Grouping bar and table pivoting, then choose Done.In the list, use a supported column’s grouping interaction, such as dragging its header into the grouping bar. Choose an available field that answers the operational question. A column that does not support grouping cannot be used this way.If a second grouping is needed, add another supported column and check the resulting group order. Start with the broader question, such as customer organization, before a more detailed category.Expand the relevant group and read its case rows. Check the case ID, current state and owner before taking action.Use the grouping bar’s removal control when a group is no longer useful, and recheck the remaining arrangement.A group label is a way to navigate the result. It does not change the cases’ Company, priority, status or ownership. To change a record, open the case or use an appropriate authorized bulk action after reviewing the exact selection.Enable Grouping bar and table pivoting in Options, then choose Done. The surrounding switches are separate personal preferences; their displayed states are examples from this agent’s setup.Choose a personal default groupingOpen Case list options → Defaults.Find Default grouping.Choose the supported default that matches your usual work, or No Grouping for a flat starting list. Available choices include Status, Priority, Issue Type, Company, Contact, Activity, Owner, Asset, Division, Case Id, Created By, Satisfaction Score and NPS. Entity labels may reflect your account terminology.Choose Done and reopen the list to verify the result. Check any separately saved view state if it changes the presentation you expected.This is a personal starting preference. A reusable view definition, a view’s saved grid state and your default grouping are different settings. Use Save this View’s state when you intend to retain supported current view state; persistence depends on your permission to edit that view. Without that permission, state can apply only to the current tab. Verify by reopening instead of assuming a visible grouping was saved for everyone.Use grouping for real support decisionsSituationRecommended approachAction to take after inspectionWeekly account reviewFilter to the intended Company and relevant open work, then group by a supported status or owner field.Identify each stalled commitment and record its next action and accountable owner.Supervisor workload reviewSelect the intended team/queue scope and group by Owner where supported.Inspect unassigned and unusually concentrated work. Consider case complexity before rebalancing.Recurring equipment issueUse reliable asset/issue filters, then group by an available relevant field.Read symptoms, versions and diagnostic evidence before concluding cases share a root cause.Cross-team handoffSelect the receiving work and group by its supported operational category.Check that the recipient has accepted responsibility and can access the case.Knowledge opportunityReview a focused set of repeated issue cases.Search for an existing guide, then improve verified reusable instructions through KCS. Group counts alone do not prove a documentation gap.These are recommended review designs, not predefined views or automatic workflow actions. A Company group does not authorize sharing all its case content with every Contact at that Company. Customer access must be checked separately.Example: several cases for one customer are waitingSuppose an account manager sees a customer group with several open cases. The group helps assemble the review, but “open” alone does not explain whether support, the customer or a third party owns the next step.Confirm that the view includes the intended cases and excludes unrelated customers. Check the date/status criteria and active list filters.Expand the customer’s group and open the cases with an unresolved commitment. Read the latest activity and the next scheduled task.Separate cases waiting for customer evidence from cases awaiting an internal investigation or a supplier response. Use actual maintained fields and case history rather than inferring the reason from age.For each case, record who owns the next action, what evidence is needed and when the next update is due. Escalate the high-impact dependency through the normal process if needed.Refresh/reopen the list after changes and verify the new state. If sharing an exported agenda, inspect the rows and audience before sending it.Grouping made the review easier to navigate; the case actions made the review useful. Keep those outcomes distinct when assessing the feature’s value.Troubleshoot missing or confusing groupsSymptomLikely cause and next stepThe grouping bar is absentCheck Case list options → Options → Grouping bar and table pivoting, then choose Done.A column will not groupThat field may not support grouping. Choose a supported field; do not assume all collected data can become a group.A case is missing from every groupCheck access, Agent/Queue scope, view criteria and active filters. Grouping cannot restore an excluded record.A group is blank or unexpectedInspect the underlying records for missing or inconsistent field values before changing the grouping.The result has too many tiny groupsRemove an overly specific grouping or reduce the nesting depth. Use filters to narrow the actual question.The grouping disappears laterCheck Default grouping versus saved view state and whether you can edit the view. Reopen to verify persistence.A colleague sees different countsCompare permissions, scope, filters and refresh time. Sharing a view does not equalize access.The grouped list does not match a KPICompare the KPI’s period, qualifying events and attribution. A current grouped case list is not automatically the KPI’s denominator.Bulk selection is unclearReview the selected case IDs and action summary before applying anything. Collapsed groups or filters can obscure what you previously selected.Continue learningDesign views and understand saved stateConfigure view filters and columnsInterpret Dashboard widgetsUse defined KPI measuresRecord and verify the next case action Was this article helpful? Yes No Thank you for your feedback.