Reporting change over prior period
I am trying to track change (positive or negative) from prior periods, but I do not know how to script in the database. Basically, it would look something like this:
Week End 1/12/2013: 7
Week End 1/19/2013: 10
Change from week prior: 3
These numbers will come from the summary line of weekly report.
Please let me know if you need further information to answer the question. Thanks.