Ignore Month selection for Dimension - Combo Chart

[#1]

I have a requirement to show a combo chart with Months as a dimension and sales and budget as measure. When the user selects any month of the year, the chart should still show all the months but data only upto selected month.

Eg: If user selects March, then combo chart should have bars for Jan,Feb and March and show 0 values for the months from Apr to Dec. Then months should not be suppressed

[swuehl]

Something like

=Sum({<MonthField = {"<=$(=Max(MonthField))"}>} SalesField) +sum({1} 0)

resp.

=Sum({<MonthField = {"<=$(=Max(MonthField))"}>} BudgetField) +sum({1} 0)

On presentation tab, disable 'suppress zero values'

[mikkeltaylor]

Hi,

I don't know if there is a solution within the chart, but hic‌ posted a good blog post here ‌that uses an "as-of" table in the script, which should accomplish what you are looking for.

Regards

Mike.