Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI Pivot Table hide null values
Hello!
I would like to hide columns that have null values in a OTBI Pivot Table, for example:
These are columns made of incentive compensation measure results for a single participant. The columns that show R$0,00 are actually null values replaced with 0. I would like the ones with "Desc." to not show when their values are null.
Is this possible?
We tried to do this:
How to suppress rows and columns with 0 value on a pivot table? — Oracle Analytics
But it did not work.
Thank you very much!
Vitor.
Answers
-
Hi
Apply filter condition in the report to display value when the values is >0 or not equal to null.
0 -
Hi @Vitor Nakamura,
Welcome to the Oracle Analytics Community.
You can use a filter like Values IS NOT NULL to eliminate the null values from the report.
If possible attach your report xml / catalog here so that we can replicate in our instance and find a potential solution.
Thank you.
0 -
