Show Field Data in Column instead of in Rows
SummaryWorking on this in OTBI
I am trying to pull in the last 2 dates an employee was paid. Currently the data appears as 2 separate rows. I am using rank right now to get the last 2 dates for "regular date earned".
|Person Number||Name||Job Title||Regular Date Earned|
I would like it so that the data appears like the below instead:
|Person Number||Name||Job Title||Regular Date Earned 1||Regular Date Earned 2|
Is this achievable in OTBI? Please advise and thanks in advance.