Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 :
Hope this will solve your req.
But i want to clear the field Plus .... i think u posted the above procedure to make selections ....
HI John,
You can use alter state property,it may help you to meet ur requirement.
find the attachment.
R/Murali.
first three steps can be used as it is and instead of "Select in Field " you can use "Clear field" action
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