Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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