As Of-Table

[Anonymous]

Current Rolling 12 should be calculated as follows using the As Of-Table:

          Sum({$<MonthDiff={"<12"}>} Sales)

How does one calculate last year rolling 12 months using As Of-Table?

[swuehl]

If you are following The As-Of Table,

{<MonthDiff = {"<12"}>} is filtering Rolling 12 for the current year only.

Create a chart with AsOfMonth as dimension and

Sum({$<MonthDiff={"<12"}>} Sales)

as expression.

You should see a Rolling 12 Month accumulation also for last year, assuming you have enough data for the historic accumulation.

[Anonymous]

Swuehl

Thank you very much for your prompt response, most appreciated.

Yes i can see a Rolling 12 Month accumulation with all historical information.  However, i wanted a separate chart for each year so that one can compare current Rolling 12 Months versus last year Rolling 12 Months.  Can this be done and if so how?

Regards.