Published: 01 May 2018 Last Modified Date: 03 May 2018
How to filter a view to the group a member belongs to.
For example, after picking one product, and then seeing all products in the same category as the chosen product.
Use a parameter to select the product, and then use a FIXED expression to create a filter that will return the same value for all rows within a group. The attached example workbook uses the sample data set Superstore to demonstrate the following directions:
Step 1: Create a parameter
In the data pane, right-click the [Product Name] field and select Create > Parameter…
In the Create Parameter dialog box, name the parameter. In this example I will call the parameter "Type in product name"
Right-click [Type in product name] in the data pane and select Show Parameter Control
Step 2: Create a calculated field
Select Analysis > Create calculated field
Name the calculated field "Selected Product's Category Filter"
Enter a formula similar to the following and click OK: