Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try a show condition in the pivot tables like
=Match( Only( {$} ListBoxField), 'For sales team') =1
Replace ListBoxField with the appropriate field name.
Try a show condition in the pivot tables like
=Match( Only( {$} ListBoxField), 'For sales team') =1
Replace ListBoxField with the appropriate field name.
Hi,
May be try this...In the Chart Layout -> Conditional Show
=GetSelectedCount(YourListBoxField)>0 andWildMatch(GetFieldSelections(YourListBoxField),'For brand managers')
It's what i need!
Thx.