Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can't you just use an IF statement in the trigger action?
If(ActiveSheetID()='SH01',YourAction)
Hope this helps,
Jason
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
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')