nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Is it possible to hide rows in a pivot table in OAC like you can in excel?

LukePa

Is it possible to have the +- sign on a pivot table which allows you to drill into the data at a lower level like the below?

Find more posts tagged with

Accepted answers

Steve F-2

You can also try the 'Row Expander' custom extension in the Oracle Analytics public library

https://www.oracle.com/business-analytics/data-visualization/extensions/

All comments

Benjamin Arnulf-Oracle

Yes - if your dimension is setup as an hierarchy, you will automatically get a little arrow sign allowing you to drill down.

LukePa

If there isn't a hierarchy is there an option in the settings to set it up this way?

LukePa

Both rows PD dealer Rel Manager and PD dealer name are in the same table of data, if there isnt a setting to drill down is there a way to create a hierarchy on the front end rather than having to get engenieering to set it up?

Steve F-2

You can also try the 'Row Expander' custom extension in the Oracle Analytics public library

https://www.oracle.com/business-analytics/data-visualization/extensions/