Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have requirement where if i select any Dimension in a table it should take me to the given SheetID.
Please help me with this ASAP.
Find the attached QVW.
Thanks & Regards,
Keerthi
like this?
UPDATE :
go to Desk and select any cell from pivot table...
You can do the same for other also.
like this?
UPDATE :
go to Desk and select any cell from pivot table...
You can do the same for other also.
Yes this is what i want. Could you please explain ???
This is done by Triggers.
Go to settings >> Document Properties >> Triggers
Go to Field Even Triggers >> Desk >> On Select >> Add Action
Add >> Layout >> Activate Sheet >>
Type
SH02
Under Sheet ID
You have to apply field event triggers for this from Settings -> Document properties -> triggers apply trigger for your field
Thanks & Regards
Setting__>Document Properties-->Trigger-->Field event trigger-->select ur field -->on select--> add action --> layout -> active sheet -->ur sheet no it will work
PFA