Create a subgroup for a single field?

Hi All,

Is it possible for me to create a group to combine related values in a field?

For instance, if I was looking at different departments in a school, and I wanted to combine Biology and Chemistry into a General Science subcategory. Is there a method to do this?

you may create a new column, we call it “Calculated field” in QuickSight. and put if/else condition in there.
For instance, if department = Biology or Chemistry, put the value as “General Science subcategory” in the new calculated field. For details, you may refer to this Ifelse - Amazon QuickSight