Calculated Dimensions and Set Expressions - Bar Chart

[#1]

Hello,

I'm trying to obtain the following result:

In a bar chart I want to see the last 3 months of a selected month (from a list box) and the next 5 weeks. I already tried with calculated dimensions and set expressions without success.

Does anyone already made something similar or can give me a tip?

Best regards,

HG

[swuehl · Accepted solution]

Maybe like attached?

I used a data island for month to select from (MonthSelect) and then a calculated dimension like:

=if(Month< MonthSelect and Month  >= addmonths(MonthSelect,-3),

     Date(Month,'YYYY-MMM'),

     if(Week >= MonthSelect and Week <= MonthSelect+5*7, Week)

     )

Hope this helps,

Stefan