The Aggregate report can have advanced filtering from data uploaded.
The filters depending on their type (Search support for Assigning Types) will have different fields to set the filter.
Boolean type will have a check box representing TRUE (when ticked) and FALSE (when not ticked)
- Date type will have a date picker
- String will have a search box. It's case sensitive. Multiple search strings can be included by comma separation
- Integer and Float will have a search box with parameters like =, >=, <=, between
These filters when applied will also be displayed in the email/pdf reports as being applied.
Exporting the data to excel will have the filtered data but won't indicate that the data has been filtered.