Bar Chart with calculated dimension (Month/Week)

[#1]

Hi,

I need help for this solution. I have a following scenario:

Time Dimension with Date, Year, Month, Week, Day and another table with Date and Value

I'm trying to build a bar chart with this information, selecting a specific date (MonthSelected) the chart will show:

- the average of values for each month for last 3 months (MonthSelected - 3)

- and the average of values for each week until 12 weeks forward

(Month-3) | (...) | (Month-1) | (MonthSelected) | (Next Week) | (Next Week +1) | (...) | (Next Week + 12)

I believe it can be done with calculated dimensions.. not sure... Any help?

Thanks in advance.