Filters
Filtering Worksheets
To enable filtering for the Worksheet, you must add a Filter to the Filters section of the Worksheet designer. This will create a filter endpoint that you must bind to a filter instance in the Workbook designer.
When adding a filter to the Worksheet, you need to specify the Data Store column to filter by. To specify the Data Store column to filter by, select the filter in the Filter Section of the Worksheet and then select the Data Store column from the properties editor.
To enable the filter column to be auto populated when a user adds a new row to the Worksheet, you need to register the filter in the Add Row Settings Worksheet Properties collection.
You add a filter to the Filters section of the Worksheet designer by dragging and dropping it.
Select the Data Store column from the properties editor.
