Latest CSW Status in Historical selection workflow report

Content

Hi, is there a way I can produce a CSW progression report which will give me the applicants latest CSW Status for each step in my workflow. 

I can report on current status and historical status' for a given workflow but would like to show the last status applicants reached for each step before moving to the next step.

I don't believe the fields exist in BO or OBI and may have to hard code with variables or put it through a mapping process in a data warehouse.  My report needs to show for each Step volume of applicants at a progression level of