Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Freeze or Hide Columns/Rows in Pivot/Table

Needs Votes
124
Views
2
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

GSO

Description (Required):

Freeze or Hide columns in OAC pivot table visualizations like in Excel.

Use Case and Business Need (Required):

When you have a pivot table visualization with multiple rows, it will be useful to have the freeze column feature available. For example if you want to compare some rows, in order to search for each one, you can freeze them.

Also, if for the moment there are some columns or rows not necessarly, there will be great to have the hide feature available and just display them on the future.

Enhancement Request / Service Request:

5
5 votes

Needs Votes · Last Updated

Delivered in September 2024 release

Comments

  • Avinash Krishnaram-Oracle
    edited Jun 6, 2025 3:43PM

    Hiding columns is supported in the product. You right click on a column in the grammar edge and hide it from the UI view (note that the hidden columns affect the grain of the query).

    Freezing columns is not available as a feature yet in Table - reopening this idea lab to support this ask.

    Note: in Pivot, row/columns are frozen by default on large pivots.

  • Ajinkya Vyawahare
    Ajinkya Vyawahare Rank 5 - Community Champion

    This is very useful feature , voted in favour