My Oracle Support Banner

How To Consolidate Multiple Rows In Data Vizualization (DV) Same As Column Formula in Home Classic (Doc ID 2870622.1)

Last updated on MAY 19, 2022

Applies to:

Oracle Analytics Cloud - Version January 2022 (6.4) and later
Information in this document applies to any platform.


Having this table of data as an example:


Is there a way to consolidate the rows in OAC DV for employees with more than one ethnicity? At the moment, when employees select more than one ethnicity, they appear in the dataset multiple times. Which results in overstated numbers for our headcount project by ethnicity.

This can be easily done in Home Classic / OAS via the creation of a 'Column Formula' in an Analysis with following logic:



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.