I have a crosstab report showing sales figures by month for each financial year. It would be useful to show the previous 12 months figures, like a rolling 12 month report. I've thought about it and cant see a way of acheiving it other than making 12 crosstab report layouts for each month as we go through the year. The thing is 12 isn't too bad but if I want to do this weekly then thats a lot of reports.
Suggestions would be great.