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

Question

I have a pivot table, and I want to be able to hide entire rows or columns if all of the values are NULL. How can I achieve this?

I tried the obvious things such as filtering out null values, combinations of filters, and changing in the view/column properties. I also tried converting any nulls to have a 0 value instead and then again filtering out the zero’s but the columns persist.

Thank you!

Riyaz Ali-Oracle · Answer

Try Modifying the Pivot Table Options:

Right-click on the pivot table and select PivotTable Options.

Under the Layout & Format tab, check For empty cells, show: and leave it blank.

This prevents empty rows from displaying.

Andra Maria Popescu-Oracle · Answer

Hello,

You can select whether to include null values in an analysis when an entire row or column contains all null values. By default, null measure values are suppressed for all analyses.

* Display the Results tab for the analysis that includes the view.
* Click View Properties.
* For example, suppose that you want to turn off null suppression for both rows and columns in a pivot table. Select Include rows with only Null values and Include columns with only Null values.

Refer:

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/suppress-null-values-views.html

Regards