Alternate state - how to use GetFieldSelection

[#1]

Throughout my document I'm using <default state> for a selected Forecast Type.

The List box for this field is set to Always one selected.

However in one of the tabs I'm trying to compare the values of two forecast types.

To get this done I've set up an alternate state <Forecast Type II>.

I've added another list box so a second Forecast Type can be selected.

So far so good.

I'm using a straight table to compare values of the choosen forecast types.

For the column header of the <default state> using GetFieldSelections() will give me the selected forecast Type.

But what do I need to do to retrieve the selected forecast type from the alternate state?

[Gysbert_Wassenaar · Accepted solution]

Getfieldselections doesn't support alternate states. You can try using the concat function instead:

concat({[MyState]} distinct MyField, ','). If you have only one selected value then only({[MyState]} MyField) works too.

[BenjaminCoe1440]

So happy I found this - solved my chart issue!