How do i link this pivot table to the next sheet when clicked on the numb

[#1]

I applied link to my pivot table expression how do I now link it to the next sheet tab.

[settu_periasamy]

Hi,

Check the Attachment, Based on Dimension Selection (not for Value)

[tamilarasu]

Check the attachment.

[Chanty4u]

Hi settu,

I didnt found the way how u done this?

Can u explain the steps how its worked?

[tamilarasu]

I have used "Field Event trigger" and Settu used "Document Event Trigger".

[settu_periasamy]

Hi Suresh,

It is just a Trigger.

You can check it in Document Properties -> Trigger

[Chanty4u]

Hmmmm jst missed it.  thnks for confrmation.

I found aftr posting the reply..

[#8]

WHat I wanna achieve is to create a link to the next sheet whixh should by by the expression on the dimension

[#9]

This isn't working on expression

[sasikanth]

If you want to see detailed table chart when click on a measure in a summary table

Then i think that is not possible here , because every measure value is based on a dimension that we have used

so corresponding dimension only be selected

and in a single row dimension value will be selected irrespective of the measures