Problem with using alternate state

[Anonymous]

Good day!

In my model i have several pivot tables with different alternate states. (They're described on attached picture.)

Also i have one list box wtih default state. All of my pivots must be invisible when i choose "For brand managers".

Because of different alternate state show object condition doesn't work.

Please, help to solve this problem (with keeping these alternate states)

Thanks.

[swuehl · Accepted solution]

Try a show condition in the pivot tables like

=Match( Only( {$} ListBoxField), 'For sales team') =1

Replace ListBoxField with the appropriate field name.

[settu_periasamy]

Hi,

May be try this...In the Chart Layout -> Conditional Show

=GetSelectedCount(YourListBoxField)>0 andWildMatch(GetFieldSelections(YourListBoxField),'For brand managers')

[Anonymous]

It's what i need!

Thx.