On Click of any random cell from Straight or pivot table it has to navigate to another sheet which contains another object

[Anonymous]

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 ?

[#2]

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.

[Anonymous]

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

[#4]

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