Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to hide/suppress empty columns in pivot tables

599321Apr 15 2009 — edited Apr 15 2009
In a pivot table, is there any way to do something like "suppress missing data" to make an entire column hidden only if it is empty? I have a situation where I can't hide an entire measure because the measure has values for another dimension, but I would like to hide the column that is empty. See the example below. I would like to hide the combination of Dim1 and Measure 2, and the combination of Dim 2 and Measure 3. I can't hide all columns with Dim1 and/or Dim2, or Measure2 and/or Measure3. Is there any way to hide just the column with the empty combination? Thanks.

Dim1 Measure1 Always populated
Dim2 Measure1 Always populated

Dim1 Measure2 Always null
Dim2 Measure2 Always populated

Dim1 Measure3 Always populated
Dim2 Measure3 Always null
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details