Report all CSW Dates for candidate application in one row

Content

Hi,

I am relatively new to Taleo Reporting and have a quesiton.

I am trying to create a report that will have the dates from each step/status for a candidate on a requisition on the same line.

Both POE - Request Sent and Ref - In Progress are CSW step Statuses in our Taleo

I have created the following formula for POE - Request Sent:

=[Application Historical CSW Event Date] Where( [Application Historical CSW Step]="POE & Quals"And[Application Historical CSW Status]="Request Sent")

and for Ref - In progress:

=[Application Historical CSW Event Date]Where([Application Historical CSW Step]="Ref Checks"And[Application Historical CSW Status]="In Progress")