1.Can we select multiple fields in select field options under trigger.
I want to select 5 Countries from list of 10 and 4 Companies from list of 15 at a time for one tab
Also this must be cleared if I moved to other tabs.
2.I have two different sources each has year,country,state in it
One is taken as Year,Country,state and other as Cyear , C COUNTRY,CSTATE .In some tabs its Year and some tabs its Cyear, So when we select year,Country,state in relavent tab and if other tabs previous selected with Cyear,ccountry then it should not reflect in selection list.
How to clear the filter should I use clear field or clear all
I was not able to define the alternate state,Can you please give example with my data.
The scenario is as below two different data in different tabs but when I select respective columns in related tabs the data it is reflecting in selection box.The selection need to restricted to that data tabs only it should not seen in other data tabs.
If you go to Document Properties -> Alternate State button you see two states. So if you add these states in different objects of your sheet it will not reflect. However, when your column names are different the data is different with other columns so selections will be default to their respective fields.
Anyways, if you right click on any objects go to properties and General tab there you can see the State selected.