Table Group By the first column

Below is a screenshot from Excel.
image

Is it possible to do the same in QuickSight?
I tried using a pivot table. The problem is that all the columns that I need are in the “Rows” section, and each column has a drilldown option. Based on the screenshot above, I only want the Class column to have the grouping/drilldown.

Thank you for your help

@desmat -
Using a pivot table, on option might be to combine the people and profession columns into a single calculated field. That would allow the drilldown to be Class - People-Profession (combined field).

1 Like

Good afternoon Kellie,
Thank you so much for the response. That’s a great idea. I will explore the option that you provided.
Have a great day.

1 Like