If your data table contains row states and you do not want to affect them, use the Local Data Filter. The actions of this data filter are temporary and you can experiment with it.
Choose how to add a Local Data Filter to a report:
- In the Report toolbar, click Local Data Filter Local Data Filter Icon.
If you don't see the Report toolbar, select View > Toolbars > Report.
- From the report's red triangle menu, select Local Data Filter.
Local Data Filter