overlapping dimension in table?

[pepe2209]

I would like to create a table that has the following dimensions:

Company	period
1	last 3 months (month 08-14 to 06-14)
1	last 6 months (month 08-14 to 03-14)
1	last 12 months (month 08-14 to 09-13)
2	last 3 months (month 08-14 to 06-14)
2	last 6 months (month 08-14 to 03-14)
2	last 12 months (month 08-14 to 09-13)

So dimension one is just company and in the second dimension i would like show the results for the last 3, 6 and 12 months of that company. So there is an overlap of months. I tried to use a dimension with distinct months (last 3, from  4 to 6, from  7 to 12) and then use accumulation or the "above" function in expressions, but I don't know what's most efficient.

your help would be much appreciated

regards,

Peter

[Gysbert_Wassenaar · Accepted solution]

Perhaps with expressions like this:

sum({<[MyDate]={'>$(=addmonths(monthend(today()),-3))'}>}Amount)

sum({<[MyDate]={'>$(=addmonths(monthend(today()),-6))'}>}Amount)

sum({<[MyDate]={'>$(=addmonths(monthend(today()),-12))'}>}Amount)