Percentage Change by Year

[Guest]

I have a report that shows the total shipments by year by summing the
Shipments in the Year Footer. I would like to have a percent change from the
previous year next to the total but can't figure out how to do that on the
report. Is that possible?

 

[Guest]

Hi

You could create a new totals query with previous years' shipments and use
this to provide the source for a box on the report and use an unbound box to
give the percentage up / down on this year.

There are quite a few methods to do this. You could create a totals query
for all years (sum on year field) and have a sub-report in the main report
showing a range of years - that would even look quite good.

etc.

Good luck