Sales Summary

  • Thread starter Thread starter tsison7
  • Start date Start date
T

tsison7

I have a table with sales figures dated from 2005 to current. I'd like a
report to show the following:

Sales for each year 2005, 06, 07
Total of sales to date
Total of sales last month
Total of sales last 3 months

I can do the first 2 no problem but I would I incorporate sales over the
last n months?
 
Sales over the last three months could be calculated in a header or footer
with an expression like:
=Sum(Abs([SalesDate]>=DateAdd("m",-3,Date())) * [SalesAmount])
 
Back
Top