I can’t seem to figure out how to group my table the way I want. In the below example, I want this table to look like it does in the screenshot, but have the Department column grouped so the user can expand/collapse departments.
If I try to switch to a pivot table, I get this but I don’t want all these expand/collapse options on my detail rows. I only want the department column grouped.