Pinned Filters

Use pinned filters to enable users to quickly filter report data based on a given field. For example, you could configure a pinned filter for the Account Number field. In the Report Viewer, users could enter different account numbers to filter the report data based on the account selected.
Optionally, you can configure a default value in the pinned filter that applies when the report is launched. Users can clear or apply a different value. You can also make your pinned filter required in the Filter Options menu during configuration. 

Pinned filters are configured during the interactive report design, and display every time the interactive report is launched. 

Advanced Filters and Sorts

Use advanced filters to refine and sort the report data with expressions which consist of fields, operators, and values, defined in the filter. 

For example, you could configure an expression to display records with a balance equal to $100, a condition type of and, then a second expression to filter for Today. When the Report Viewer is opened, only records that have both a balance of $100 and the current data would display. If your condition type is or, records that have either a balance of $100 or the data of Today would display. Learn more in Advanced Filter.

Advanced filters require a value to be populated during the interactive report design. Users can change or clear the advanced filters while in the Report Viewer, but changes do not persist.