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

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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?

Accepted answer
42
Views
4
Comments
LukePa
LukePa Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

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?

image.png

Best Answer

  • SteveF-Oracle
    SteveF-Oracle Mod
    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/

Answers

  • Benjamin Arnulf-Oracle
    Benjamin Arnulf-Oracle Admin
    edited Mar 17, 2025 3:02PM

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

  • LukePa
    LukePa Rank 4 - Community Specialist

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

    image.png
  • LukePa
    LukePa Rank 4 - Community Specialist

    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?