I want to do a report that shows sales broken down by year over the past 10 years. BUT, I don't want the year to be the calendar year. I want it to be June 1-May 31 of each year.

So, for example:

Revenue for Product/Service A: $

6/1/12 through 5/31/13: $100,000
6/1/13 through 5/31/14: $94,000
6/1/14 through 5/31/15: $106,000
ETC.

I've got everything figured out except how to break it down by year that's not the calendar year. Trying to sort out product A by year only shows Jan1 - Dec. 31. But the service I want to break down is a winter service, so I want to see how it corelates with Winter seasons, not calendar years.

It's gotta be possible, right?