Accpac Budget vs Actuals for rolling 12 months

Hi all, I'm wondering if anyone has created a budget vs actual comparison for a rolling 12 months period? I have created one using an Intelligence data dump one but not sure if it's the most efficient way to roll it out. Essentially a reporting month is input, appropriate columns are determined from that date (example: For reporting month of July columns are ACTUALS07 -ACTUALS01, LASTYR12 - LASTYR06) and calculations are driven from that. Does Intelligence have anything built in that will do such a comparision or is there an easier way I am missing?

Thanks in advance,

Jim