Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement is that, All the selections done in one sheet should be restricted to that one sheet only.
i.e, it should not reflect on another sheet.
Came to know that by using alternate state we can achieve that.
Can any one help me out to get the same.
Thanks & Regards,
Sasi Vardhan KV
Hi
Well alternate state is the best way to achieve this, but you can also do this with the sheet activate and sheet de-activate triggers:
HTH
Jonathan
Hi
Well alternate state is the best way to achieve this, but you can also do this with the sheet activate and sheet de-activate triggers:
HTH
Jonathan
To create alternate state,
Go to Document Properties window, in the General tab you can find the button called "Alternate States", click that and Add "Sheet1", Sheet2, etc., till the no. of sheets you have in ur application.
Then in each sheet, go to the property of each object and in General tab select the sheet name in the "Alternat State" drop down box.
This will achieve your need.
Give your sheet an alternatestate. Then other sheets wont be affected
NOTICE: You cannot use $sign in your set analysis.
Hi All,
I need help here to assign two alternate state in one sheet.
I have created two alternate state = state_1,state_2
Total 6 charts and various field list
Eg:
Say I have a two field list say Country , Business Unit
Case 1 : If i assign state_1 for Country field and state_1 for Chart 1 which means if we select Country field its going to change Chart 1 only
Case 2: If i also assign state_2 to Country field & Business Unit and state_2 for Chart 1 + Chart 2 here if you select country field and business unit - Chart 1 & 2 has to change
Here Chart 1 and Chart 2 has intersection of states (both state_1 & state_2) where as it gives me to choose only one state
Is it possible ? If so how ?