list box

[smilingjohn]

HI All ,

i have two tabs one is main tab which has bar charts and line charts in it is related to sales data

and the other tab is Deatail this tab has information about employees and sales details too .

now in the Detai tab i use a filter called

"Plus" within which the content is like "Level One" and this filter "Plus " i used as a filter when i click on Level one , all the Detail tab show the sales related to only Level One employee

and when click on Main tab there also the values change according to the selection of Level one , where as i have not used Plus list box here .

My rewuirement is like

Whenever i Navigate to Main tab , the plus filter (Level One ) should get deselected .. can i achieve this ?

Thanks in advance

[punitpopli]

You can use select in field in Sheet event trigger and place a list box on the sheet for testing and can hide later.

How this will work :

• Goto sheet properties
• Triggers
• OnActivateSheet
• Select - Select in field
• In the Field use Plus filter
• In Search String enter level one and
• click on apply
• Save

Hope this will solve your req.

[smilingjohn]

But i want to clear the field Plus .... i think u posted the above procedure to make selections ....

[Anonymous]

HI John,

You can use alter state property,it may help you to meet ur requirement.

find the attachment.

R/Murali.

[punitpopli]

first three steps can be used as it is and instead of "Select in Field " you can use "Clear field" action

[avinashelite · Accepted solution]

In the Sheet level triggers we have option to select and deselect a filed ..go to sheet properties > Triggers > On Activate > Select the option to clear the field and mention the filed to clear