How to hide null value in Pivot table for one column — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to hide null value in Pivot table for one column

Received Response
232
Views
5
Comments
3184221
3184221 Rank 3 - Community Apprentice

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.

pastedImage_0.png

Answers

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    Have a filter on Service column thats says "is not null"

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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?

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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.