BI Publisher (MOSC)

MOSC Banner

How to conditionally hide headers in pivots (created using crosstab function) created in RTF?

edited Oct 3, 2019 5:00AM in BI Publisher (MOSC) 1 commentAnswered

Hi.

I have created a pivot table in RTF.

The issue is the headers in the pivot table may have blank data & therefore it shows up in the report as blank.

Example below (circled area should not show up in the report; i.e. there are the fields I want to hide.

I cannot remove these in the data model as it will remove other data I need for this report.

I have tried editing the crosstab function without any luck. Also I am not too savy when it comes to understanding or editing the crosstab function.

Thanks.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center