Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Is it possible to hide rows in a pivot table in OAC like you can in excel?

LukePa
Rank 4 - Community Specialist
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?
2
Best Answer
-
You can also try the 'Row Expander' custom extension in the Oracle Analytics public library
https://www.oracle.com/business-analytics/data-visualization/extensions/2
Answers
-
Yes - if your dimension is setup as an hierarchy, you will automatically get a little arrow sign allowing you to drill down.
2 -
If there isn't a hierarchy is there an option in the settings to set it up this way?
0 -
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?
0