Hiding of rows in pivot table view — 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

Hiding of rows in pivot table view

Received Response
1
Views
1
Comments
3024008
3024008 Rank 1 - Community Starter
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

Hi,

I want to hide the rows in a pivot table view based on a conditon. for ex:

i have a pivot view with following structure

 

Op CodeVoyageop costrunning costtotal
v1010011001101
20000
30100100200

Now i need to hide the row which has total 0.. the measure are coming from same column but not calculated in OBIEE.

Regards

Sreekanth

Answers

  • jprakash
    jprakash Rank 2 - Community Beginner

    Sreekanth,

    You can achieve using selection step.

    • Right-click a row at left most column (Op Code in ur case)
    • From the context menu choose the column name( Op Code) -> Remove -> Based on Custom Codition. In my case the column name is "Per Name Month"

    selstep.png

    • Choose the condition for total "0"

    cond.png

    Thats it. You are done!

    Thanks, JP