Alternate States

[microwin88x]

Hello,

I have an app with the following objects (it has Alternate States):

Then I have the following expressions for the chart:

1 - SUM({[GROUP_1]<MATERIAL={'05'}}>}SALES)

2 - SUM({[GROUP_2]<MATERIAL={'05'}}>}SALES)

With the Dimension = Period (MMM-YY)

What I need is that if I select a Year from the listbox, for example, 2015, it should show me Jan-15 to Dec-15 in the chart.

As the Listbox for Year has an Alternate State = Inherited,

And the Multiple Selection Box 1 for Group 1 has Alternate State = Group 1

And the Multiple Selection Box 1 for Group 2 has Alternate State = Group 2

The Year selection doesn't reflect the value in the chart. Is there any way to do that?

Thank you!!!

[CarlosAMonroy · Accepted solution]

Hi,

You can try the following expression:

1 - SUM({[GROUP_1]<Year = $:: Year, MATERIAL={'05'}}>}SALES)

2 - SUM({[GROUP_2]<Year = $:: Year, MATERIAL={'05'}}>}SALES)

If that does not work, would be great if you can share a sample app.

Carlos