Cases opened/closed widget — how to group by both "Assigned Team" and "Category"?

Hi Community,

I'm working on a Cases opened/closed by Assigned Team (monthly) dashboard widget and have run into a limitation I'm hoping someone can help with.

Requirement: Our Head of Department wants to view cases grouped by both Assigned Team and Category as columns in the same chart widget — for a quick breakdown at a glance.

Problem: Out of the box, the widget only allows a single "Group by" field. When I set it to "Assigned Team", I lose the Category breakdown — and vice versa. There's no built-in option to add a second grouping column.

What I'm looking for: A way to group by both Assigned Team and Category in one widget — any workaround, configuration tip, or recommended approach would be greatly appreciated.