Transpose rows to columns in OTBI
SummaryI need to build a report that shows every employee as a column. Convert all rows to Columns in OTBI
I hope you can help me. I need to build a report that shows every employee as a column.
|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 Start Date||04/06/2020||08/06/2020||04/06/2020|
|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).