We would greatly benefit from this information collapsed into one line per individual as well. We are considering Caroline's workaround and another option but the options will take additional time / effort to set up as well as ongoing maintenance.

@Caroline Blanchard thanks for your response - We are exploring this as an option as well as a semantic extension. I upvoted your idea and will comment we (and I believe many other US based companies) could really benefit from it being standard configuration provided by Oracle.

Hi John - I did go ahead and post it there, but it seems like that might be for OTBI reports? Does this forum also support FDI customers? https://community.oracle.com/customerconnect/discussion/820968/ethnicity-all-headcount-for-us-legislation-to-include-two-or-more-races/p1?new=1