Comparing current sales with dynamic sales from previous year

[mgxdigital]

Hello All,

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.

Please help!

Thanks!

[comment]

It would help knowing what method are you using for displaying the comparison (report, portal or ??).

[mr_vodka]

As per your cross post on another forum, here is a sample file.

http://forum-en.filemaker.com/fm/board/message?board.id=FM-en-4&message.id=13500

LastYear.zip