Dynamic figures by year calculation
I am trying to do comparisons of sales between a month and the previous year's same month.
So say this month so far, i have $50,000 in sales, I want to compare that to May 2008 sales.
I have the dates down. I can show this month and i can show all of the previous year month.
The problem that I am running into is making the previous year month dynamic as the current month is.
This is how my calc work now.
This May 2009 so far i have $50,000 in sales, May 2008 it will show $250,000 in sales.
It is showing the entire past month, not keeping it up to date with where we currently are in the current month.
I would like it to show this month's sales up until today and the previous years month up until the current date.
May 4th 2009 - $50,000
May 4th 2008 - $48,000
This way we can see how the month is going without having to wait until the end of the month to compare figures.