Hi, I have last year's report with sales, profit and margin for each month of the financial year.
I will be creating a new report for this financial year and need to compare current YTD with last YTD. YTD for this year is easy. but is there a formula to calculate the comparitive YTD figure for last year?
For example, when May 2007 figures are entered, I want to compare May 2007 with May 2006. When June 2007 figures are entered I want to compare May to June 2007 with May to June 2006 (and so on through the year) but without re-calculating the YTD figures each time for last year.
Any ideas?
Many thanks
Bookmarks