Remove row with two filters

[Anonymous]

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

[JarroVGIT]

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]

Doesn't work because row 204, 205, 206... will be deleted and I just want delete rows 197, 198 and 203. Following the steps

[JarroVGIT]

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 0

Then 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 🙂

[parry2k · Accepted solution]

@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)

[amitchandak]

Have you tried In edit query mode? You have options for row operations.  On home tab, edit query option.