Create and Bind a Parameter to a Workbook Filter

Select a workbook filter's data values and then use the Create Parameter option to create and bind a parameter to the filter. After you create the parameter, you can bind it to other filters in the workbook to pass data values between filters.

The parameter you create uses the filter's selected values and corresponding column's name as its properties, and is added to the workbook's Parameters tab. The parameter shares the filtered column's name, for example, if you bind a parameter to a City column filter, the binding creates a parameter named City.

For more information about how to use parameter binding in a workbook's filters, see About Binding Parameters to Filters.

You can also select an existing parameter to bind to the workbook filter. See Bind an Existing Parameter to a Filter.

1. On the Home page, select the workbook where you want to create a workbook filter and add and bind a parameter to, click Actions, and then select Open.
2. Create or locate and click the workbook filter where you want to create and bind the parameter.
3. Optional: Select the filter values.
4. Click Bind to Parameter (x) and then click Create Parameter to create and bind the parameter to the filter.
5. Optional: Go to the workbook's Data Panel, click Parameters, right-click the parameter you created from the filter, and select Edit Parameter to review and update the parameter's properties. Click OK.