My Oracle Support Banner

FA: SCM: SCP: Unable to Hide/Remove Empty Rows and Columns in Pivot Tables Using Advanced Filter Option in the Table Configuration (Doc ID 2671315.1)

Last updated on MAY 28, 2020

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Goal

Need to hide/remove empty rows and columns in pivot tables and to achieve this, Advanced Filter option under Table configuration is used. Under Measure Criteria tab, condition set is 'Measure value is not null'.

But the results are not as expected.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.