i wanna use link representation in pivot to a new sheet.

[#1]

How do i link my expression (values) in my pivot table to open a new sheet? what do i do?

[Anonymous]

Not sure what you are doing but may be this could be helpful:

In your expression put: '<url>your link domain'

Give it a label name

Select Link as Representation.

If not url then maybe check around QV trigger actions.

Best,

[nagireddy_qv]

Hi,

In the expressions tab, try to use the function 'GETACTIVESHEETID'.

Also, remember to change the representation type to "Link" in the chart properties.

[#4]

I dont understand, plz be more detailed

[#5]

Please i still dont understand. I wanna use the URL to open another sheet from the table