In OAC is there a way to suppress rows for groups where the value of that grouping is set to null

Question

Within a report we are using a table visualization and have created grouping options as part of the dashboard filters.   The ask is if a user chooses to leave say Grouping option 2 and 3 and 4 set to null when the table subtotals can the visualization ignore those groupings that are set to a null value.   Attached an example of the output.  We are looking to hide those rows identified as 'hide'.  Looking to understand what options we have in OAC.

RVohra · Answer

@Karen Lundquist-Oracle , Welcome to the Oracle Analytics and AI Community!

You can give it a try by introducing a flag in your query …

CASE   WHEN Group2 IS NULL AND Group3 IS NULL AND Group4 IS NULL

THEN 'HIDE'

ELSE 'SHOW'

END

Then Filter → SHOW only

GayathriAnand-Oracle · Answer

You can try using Selection Steps in classic and create a custom group or custom calculated item for your use case. Please refer to product documentation for selection steps/calculated item/group :

https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/groups-and-calculated-items1.html

Thanks

Gayathri