Use trigger to set selections in an alternate state

[Anonymous]

Hello everyone,

I have users making selections in other sheets, but when they open up a particular tab (which is in a alternate state), the location should be set to the location they selected for the other sheets.

Is it possible to set selections within an alternate state using a trigger?

Alternatively, can I avoid using an alternate state completely and just have a listbox ignore other selections?

Thank you in advance!

[micheledenardi]

Hi David,

In your objects in the alternate state sheet change your expression and use set analysis like:

sum({Group1} <Location=$::Location> Sales)

Legend:

{Group1}: the expression refer to Group1 alternate state selection.

Location=$::Location: for the "Location" field, the expression consider the "default state" of your document (so the state for the other sheets).

[vishsaggi]

Can you share somemore information and expected output with some sample data. We might be able to take off Alternate States and Ignore selections using set analysis. I cant assume unless i can see some expected output.