how to have a field triggers in just one sheet

[Anonymous]

so i have chart and in document properties i activated field triggers by selection on that  dimension it shows show a sheet......

but that field is used as a common list box all over my dashboard ..how to confine my trigger to one one sheet

[Jason_Michaelides]

Can't you just use an IF statement in the trigger action?

If(ActiveSheetID()='SH01',YourAction)

Hope this helps,

Jason

[Anonymous]

thanks jason for your reply....................

crrt me if i'm wrong.......it's seems to me that a macro's is needed.....is there any other way we can do this without writing a macro's...

Thanks

Srikanth

[Jason_Michaelides]

Don't think so. Let's say you have 3 sheets, SH01, SH02 and SH03. SH01 has a chart with dimension "Country" and SH02 and SH03 both have a list box of "Country". My understanding of what you want is if a user clicks a country in the chart in sheet1 you want to activate sheet2. However if a user selects a different country on sheet3 you don't want to activate sheet2.

If I'm right then I think my solution above should work fine. Add an Activate Sheet action to the OnSelection trigger of field "Country". In the expression box enter:

If(ActiveSheetID()='SH01','SH02')