Comparing current Job Titles to previous week Job Titles in OTBI

Summary:

Hi, I've been tasked to compare current Job Titles to Job Titles in the previous week. Can anyone assist in explaining how this can be done via an OTBI reports as I would like to schedule this report on a weekly basis to the Requestor.

Content (required):

I'll need to set up a report that lists employee's in a department with their current Job Title and in an adjacent column the Job Title they held in the previous week. I'll be creating a custom column at the end that lists three values "No Change", "Job Change" and "New Starter".