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

AjayKumar Maddipati

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

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

https://docs.oracle.com/middleware/12213/biee/BIEUG/GUID-843DD4CA-B575-4752-82DE-831768C1215D.htm#GUID-2B184B01-1FA5-4A09-9D4B-2F49227FE122