Last Modified Date: 05 Dec 2016
- Create a calculated field similar to the following:
IF [Parameter] = [Field] THEN [Field]
- Place the field on the Filters shelf of the worksheet you would like to filter.
- In the Filter dialog box, check Exclude and Null.
- Publish the workbook.
- The published view can no be filtered with the parameter as a URL parameter as follows:
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials