I'll appreciate some assistance to convert the attached chart to a Rolling 12 month report.
I have revieweed some samples shown in the community but, after a couple of days of trying different scenarios, with different formulas, I still cannot generate the Rolling 12 chart. It is problably a simple thing however, I cannot figure it out.
Thank you very much for any tips that you can provide.
It would be a good idea to change the X-axis so that it looks at MMM-YY, as otherwise should you select a mid year month then Jan-14 will appear before Jul-13 and there will be a disconnect between months.
You could solve this with a fancy formula in the sort tab, but for clarity's sake it would be best to show the month also.