Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle Fusion OTBI > Ability to Rotate Rows Into Columns

Question
1
Views
0
Comments

Hello,

We would like to design a report where the columns ‘Date’, ‘Time Entry Start Date and Time’, and ‘Time Entry End Date and Time’ are rotated. Please find below screenshots

Screenshot_00.png

We have tried to design the same report on OTBI using Pivot table, dragging the column ‘Time Entry End Date and Time’ into the Measures; however, it does not work. Any idea ?

Screenshot_01.png Screenshot_02.png Screenshot_03.png

Thanks

Bernard