Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to hide null value in Pivot table for one column
In Pivot table there is a null value and requirement is don't want to see null values in Pivot Table.
I can't filter it on Report level because it will filter the data.is there any way i can do it in The Column Level to hide the Null values.
Example :- In service Column don't want to see null and corresponding values.
Answers
-
Have a filter on Service column thats says "is not null"
0 -
Use conditional formatting to turn the content font the same colour as the background when the value is null, but wouldn't it not add up then?
0 -
Robert Angel 's answer , I read it again. You can do what Robert said, but that will show 1 empty line. Other option is using selection step to eliminate null Service value. More about that is here...
https://docs.oracle.com/cd/E28280_01/bi.1111/e10544/filter.htm#BIEUG131
Thanks
Arijit
0 -
Why not correct the actual issue rather than pushing it under the carpet?
Solve the data quality issue in the source system?
Solve the data quality issue in the ETL?
Make the poor data quality visible by putting 'Invalid data' or 'Unassigned' for example?
Analytics should not have to cheat because the data is poor.
0 -
Selection step is a good idea - take population less one null value....
Have to side with Christian on sorting out the underlying data issues, or at least quarantining them until they can be resolved.
0