Im currently using a variable to limit the values in a pivot table using this expression if(dashboard=vIndicator, sum(value)) .
The only drawback with this is all the availble options are shown in my filter. Is it possible to limit the values shown in my 'Question' filter depending on what variable is held in vIndicator?
For example my data set has a number of questions split to 2 Dashboard Values. At the moment all the questions are shown in the filter regardless of what variable has been selected by the user.
See attached file. If you input a product name in the input box you'll notice that the selection of the Product listbox changes, as does the chart. On the Triggers tab of the Document properties you can see that the variable value has an action assigned to it. If you click on the button Edit Action(s) under OnInput you can inspect the action and its arguments.
You can use a OnInput Variable Event Trigger to make a selection in a field with a Select in Field action. It sounds like you want to select in field dashboard and set the search string to =vIndicator
See attached file. If you input a product name in the input box you'll notice that the selection of the Product listbox changes, as does the chart. On the Triggers tab of the Document properties you can see that the variable value has an action assigned to it. If you click on the button Edit Action(s) under OnInput you can inspect the action and its arguments.
