Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.