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.
Add a Local Data Filter to a report:
- Click the right arrow at the top of the report window and select Local Data Filter.
Local Data Filter Option
If the report window is wide enough, click the Local Data Filter icon that appears on the right side of the toolbar.
Local Data Filter Icon
Local Data Filter