I can see two simple options.
1) create a calc that builds an additional column. The calc could be as follows:
when "Older" then 1
when "Younger" then 1
when "More Educated" then 2
when "Less Educated" then 2
when "Higher Income" then 3
when "Lower Income" then 3
when "Overall" then 4
You could either use integers and then label the aliases or you could go straight to strings.
2) Create a secondary datasource and blend:
Group Hierarchy Lower Income Income Less Educated Education Younger Age Overall Overall Higher Income Income More Educated Education Older Age
Please see the attached workbook.
Health Literacy.twbx 35.7 KB