Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI 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 -
