Grouping Ethnicities

Summary

Grouping ethnicities after a single row of data has been calculated

Content

Hi everyone,

Using this post, I was able to successfully get an ethnicity report to return one row of data to show Hispanic or Latino, two or more races or the selected ethnicity.

I am seeking guidance on how to group/case the ethnicity display. I believe this could be a case statement but I'm not sure how to approach as there is already a formula in the Ethnicity Display. For example, I would like to group American Indian and Native Hawaiian as "Other". Will appreciate any possible solutions or general comments. I've attached the sample report that contains the ethnicity display.