how can I get multiple seniority dates on the same row in OTBI
I am reporting from assignment real time, person real time, and person seniority real time. When I have Seniority Date showing, there is one row with the enterprise date and one with the job change date. I want only one row but I need those two dates in different columns. Can anyone help?
Version (include the version you are using, if applicable):