Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Transpose rows to columns in OTBI — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Transpose rows to columns in OTBI

Accepted answer
81
Views
3
Comments
edited Jun 13, 2020 11:13PM in Reporting and Analytics for HCM 3 comments

Summary

I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBI

Content

Hi

I hope you can help me. I need to build a report that shows every employee as a column.

Example:

Person ID Person Start Date Last Name Person Gender Creation Date
300,000,043,368,135. 04/06/2020 Test Male 04/06/2020 14:07 t
300,000,043,368,847. 08/06/2020 Galvan Male 09/06/2020 12:54 t
300,000,043,648,474. 04/06/2020 Test Male 04/06/2020 14:21 t

 

In need to show it like this:

 

Person ID 300,000,043,368,135. 300,000,043,368,847. 300,000,043,648,474.
Person Start Date 04/06/2020 08/06/2020 04/06/2020
Last Name Test Galvan Test
Person Gender Male Male Male
Creation Date 04/06/2020 14:07 t 09/06/2020 12:54 t 04/06/2020 14:21 t
Email Type   Work Email  

 

I was trying to use Pivot Table, and moved all rows to columns, however I cannot  find how to put the header in the first columns. I got something like (without header in row).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!