How to set triggers on calculated dimension and how to lock/unlock a field on leaving sheet from one to other sheet.
Ex: this is how data is being displayed in straight table, where 1,2,3 are the result of calculated dimension in sheet X, upon selection 1 in the table, it display only that row when we move from sheet X to Sheet Y which has the same straight table when we click on 1 it has to come normal state displaying 3 rows, which is not happening.
I don't think this need any trigger. This is what should be happening by default. Can you share a sample which shows that this is not what is happening?
When we are in the same sheet its working Sunny, but when we move from one sheet to the other its not working the selection in the current selection box is getting unlocked. may i know whether we can implement a action/trigger on calculated dimension.
it seems like it is a simple issue that can be cured by changing Sheet Properties. So for Sheet Y where u dont want the selection from X to carry over, you can go to sheet properties ----------> Triggers ---------> On Activate sheet ----------->
add Action------------> Clear All. so when u select 1 in sheet X and go to Y, Y, it will have a normal state with out any selections carried over. hth
