The following section describes how to add a filter to a Pivot Table in order to analyze the data you have collected.
- To add a filter to a Pivot Table, you first need to add a measure. In this example, the measure added is the “Count of all records” as shown in the screenshot below.
- Drag and drop the dimension from field to “Rows”. In this example, the dimension used is the “Education level” of participants
- Drag and drop a filter (from the existing fields in your form) to “Filter by” area. In this example, we have used the gender field as a filter
- Choose the specific category or categories to include in the report
- The filter has been added and you can view it on the Pivot Table
- You can add as many filters as you need in your Pivot Table by dragging additional fields into “Filter by”
it is important to note that when a corresponding dimension is added, only the rows that match the filter will be displayed when using a calculated measure. On the other hand, if a corresponding dimension is not present, the displayed value will be adjusted to reflect the applied filter. This ensures that the calculated measure dynamically adapts to the filtering conditions and provides accurate results.
NOTE: At this time, only filtering by discrete categories is supported. We plan on enabling rule-based filtering in a future release.