Forum Discussion
Remove row with two filters
How do I remove rows following two steps.
First: filter all null cells in collum T
Second: filter all cells that contains any value in collum S
then delete rows
Anonymous in formula bar update your filter expression as below, first filter column T by selecting a value and then on filter row step, update the expression as below
([T] <> null and [S]<>null) or [S]=null)
5 Replies
Have you tried In edit query mode? You have options for row operations. On home tab, edit query option.
You can filter in the query editor, that removes all filtered rows from the dataset. See example dataset (opened in query editor!):
Now filter out null values by pressing the dropdown menu and deselect null.
Repeat for the second column, then press Close and Apply and the rows are removed from you available data in the report view.
Kind regards
Djerro123
------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Kudo's are welcome 🙂
Anonymous in formula bar update your filter expression as below, first filter column T by selecting a value and then on filter row step, update the expression as below
([T] <> null and [S]<>null) or [S]=null)
