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.
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.
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.
