OTBI Pivot Table hide null values

Question

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.

Riyaz Ali-Oracle · Answer

Please check the below:

Suppress Null Values in Views

How to suppress rows and columns with 0 value on a pivot table? — Oracle Analytics

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/26030/otbi-pivot-table-hide-null-values

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.

Rajasekhar Bandaru-Oracle · Answer

Hi

Apply filter condition in the report to display value when the values is >0 or not equal to null.