How to Filter Members Using Design Manager in SpotlightXL

Filtering member options is helpful when updating an existing report, finding specific report dimension members, and previewing members you might filter.

Filter Member

To use Filter Member: 

1. Open a report in design mode by selecting the Report > Design.
2. Select the entire spreadsheet and click Design Manager.
   
   
3. Select a dimension member and select Filter Member.
   

Preview Filter Member

To use Preview Filter Member:

1. Open a report in design mode by selecting the Report > Design. 
2. Select the entire spreadsheet and click Design Manager. 
3. Select a dimension member you want to preview before filtering. 

The result is that the cell range is displayed as shown below. This way you know exactly where the member exists within the report.