Categories
- All Categories
- Oracle Analytics Learning Hub
- 31 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 250 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 93 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Hiding of rows in pivot table view
3024008
Rank 1 - Community Starter
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 Code | Voyage | op cost | running cost | total |
| v | 10 | 1001 | 100 | 1101 |
| 20 | 0 | 0 | 0 | |
| 30 | 100 | 100 | 200 |
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
0
Answers
-
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"
- Choose the condition for total "0"
Thats it. You are done!
Thanks, JP
0