Selection from a straight table with alternate states expressions

[dana]

Hi,

I have a straight table with a couple of dims, and  an expression  referring to a  state.

when trying to select a specific dim value, the table doesn't reflect it. 

What is the reason and is it achievable? 

Thanks.. 

[fosuzuki · Accepted solution]

Hi Dana,

probably the issue is that your table is tied to the default State. So when you make selections in the dim, the selections are associated with the default state. And as the expression is tied to a different state, the expression values won't change.

Try changing the table's state. Go to chart properties > Appearance > Alternate states.

[Or]

In addition to what has already been suggested, check that the selection you are trying to make isn't actively excluded from the current state.

e.g. if your dimension in the default state is Year, and your expression the sum of last year's sales (e.g. year =2020, sales are for 2019), there may be no matching values if there were sales in 2019 but not in 2020. This can result in odd behavior when attempting to make selections.

[dana]

You are right!

defining the state for the table resolved it.

Thanks!