w ehave OTBi Report skills and certfications but it showing unparallely ?

AjayKumar Maddipati · May 23, 2023 11:48AM

HI Team,

We have report facing this is how can sorted .

How it looks in the report

How we need it to look like:

SqL for query.txt

Nathan CCC · May 23, 2023 11:52AM

Hi, Try a pivot table. You will need a column that says whether each row is type Skill or type Certificate.

Oracle® Fusion Middleware

User's Guide for Oracle Business Intelligence Enterprise Edition

12.2.1.3.0

E80922-02

November 2017

MFA for Oracle Community