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