Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
On some sheets I have Fields built into expressions. I'd like to have these fields excluded from the Selection Box to avoid confusion since they don't affect the charts.. However, in other sheets I want to allow the user to select these fields. How can I do this? Using HidePrefix spans all sheets which I don't want. I suppse I could use Alternate States but would rather not create all the extra work .. Any Ideas?
Thanks,
John
I have the same question...
Add a tag to your field in the script :
Tag Fields [YourField] with $hidden;
Michael
creates two fields with the same content, one hidden one visible, and use these in different tabs
Thanks for the reply.
I import my data from Excel Files, where do I write $hidden ?
Lucas
In the laod script, after the load statement from excel...