Forum Discussion
Remove row with two filters
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)
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 🙂
Doesn't work because row 204, 205, 206... will be deleted and I just want delete rows 197, 198 and 203. Following the steps
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)Ah oke that clarifies. Try adding a Custom Column (from Query Editor, tab Add Column) with the follwing:
= if [T] = null and [S] <> null then 1 else 0Then filter out the 1's in the new column as per my previous post.
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 🙂