Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
