how to assign 2 alternate states to one list box

[#1]

Dear Gurus,

I have created a chart with 1 Dimension(Month) and 2 expressions.

I have 2 alternate states StateA and StateB

In the above chart 1st expression is like sum({StateA}Sales) and 2nd expression is like sum({StateB}Sales)

Note: Chart is not assigned to any particular state.

Sales are being changed when I make the selections in StateA or StateB related list boxes.

Problem is:  I have Month list box which is not assigned to any Alternate state. If  I make any selections on Month list box , my chart is not filtered for selected months.

Is there any way I can assign 2 alternate states to this Month list box as Month is a common dimension in my chart for the above 2 expressions.

Please guide.

BR,

Chinna

[mightyqlikers]

Hi,

create two list boxes for month field and assign alternate states one each.

then chart will reflect as per the selections

Regards

Samwise

[tresesco · Accepted solution]

If you want the Default state's selection to be considered in your expression, try like:

sum({StateA} <Month=$::Month> Sales)

[#4]

Thank You Tresesco. This is what I was looking for..Many thanks