I have a report which I need to automate because it angers me to no end...
Takes me almost an entire day to produce a dozen reports.
On a quarterly basis, we produce a report where figures are based on 6 monthly rolling trend.
For example, when we run this report in march, there will be 3 new figures:
Aug - Jan
Sep - Feb
Oct - Mar
At the moment, what we are doing is exporting each month into a spreadsheet then doing calculations on these figures to get the 6 month figure.
The data is currently stuck in many different places and I plan to get everything in one place to hopefully run one query (or a procedure, or report) to get the figures I want.
My question is... how would I go about doing this because the same data could be in multiple rows?