Using a proxy month for financial analysis

[DWig]

Hey all, it's me again.

I have a pivot with several linked tables.
Table Job contains:
Job Code (unique identifier)
CloseDate (the date the job was sold)
Month1 (Financial period 1 month after job was sold)
Month2 (Financial period 2 months after job was sold)
... (3-11)
Month12 (Financial period 3 months after job was sold)

Table Job Cost Detail contains:
Amount
Financial Period
Job Code (this links to Job Code in Table Job)

I'm trying to put Months 1-12 as column headers and get values for lagging amounts spent in the twelve months after a job is sold. Any ideas?

 

[DWig]

Cross-posted on the Microsoft board.