Is there a way to create a dimension that is based on overlapping ranges?

For example in my fact table I have a datetime column. I would like to
create a dimension that groups rows in my fact table that overlap. So the
dimension members would be
"June 2003 - May 2004" and
"July 2003 - June 2004" and
"August 2003 - July 2004"

The idea is that rows in the fact table may belong to any or all of the
members in the dimension. Lets say I was measuring some dollar value. I
would want to display this dollar value for the 3 periods side by side in a
pivot table.

Is this possible??

Thanks.