Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 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 suppress rows and columns with 0 value on a pivot table?
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!
Answers
-
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.htmlRegards
0 -
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.
0
