Use link in table to set variable

[Janneke]

Hi all,

I would like to have the functionality of an URL-link in an expression of a pivot table, but instead of the URL, I want to set a variable. So, if I click on the value, I would like to affect variables (and with that pop up a text object with different texts).

Normally I use a text object with actions for this purpose. However, since in a pivot table the position of the lines can change, this is not an option for me.

Thank you for thinking with me!

Janneke.

[stigchel · Accepted solution]

When you click in a chart you select the associated values in the field(s) of the dimension(s), you can use that to set a field trigger that will set a variable.

To  make it look like a clickable link in the pivot table you can add an expression e.g. ='Link' and the format to blue and underlined.