Transpose rows to columns in OTBI
Summary
I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBIContent
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).
Tagged:
1