Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
On Click of any random cell from Straight or pivot table it has to navigate to another sheet which contains another object ?
Eno | Compnay name |
1 | Test |
2 | Test2 |
3 | Test3 |
4 | Test4 |
5 | Test5 |
6 | Test6 |
7 | Test7 |
Assume i have clicked Test cell ,it has to navigate to another sheet which contains another object.
Let us know whether above expected functionality is possible or not ?
Hi Anil,
you can use field Triggers for this.
Go to Settings-->Document Properties-->Triggers--> Select the column name in Field Event Triggers section and an action.
Hi Shruthi,
Thanks for the quick response and I appreciate the concern.
In General expression is a combination of differnet fileds.
How can i use the either lable or the particular cell in the form of trigger?
In Advance,
Thank you
Hi Anil,
Eventhough expression is a combination of fields. when you click on the expression the dimensions in the particular will get selected. so it internally chnages the field selection.Hence you can put the field trigger on the dimensions used in the table to get the reuired functionality.
Regards,
Shruthi