Filter children excluding top summary rows

Noelle Nordstrom

Is there a way to filter children rows using the green, red and blue balls, excluding the summary rows using above the parent row using the filter feature?

Every time I use the filter feature in the Sheet it filters all rows even if I lock the top summary rows.

Paul Newcome

To accomplish this, I generally add in a hidden "helper" checkbox column called "Header". Then I check all of the boxes for my header rows.

From there, the first tier of your sort would be by the Header column (Descending) and your second tier would be by whatever you wanted it to be.

Paul Newcome

To accomplish this, I generally add in a hidden "helper" checkbox column called "Header". Then I check all of the boxes for my header rows.

From there, the first tier of your sort would be by the Header column (Descending) and your second tier would be by whatever you wanted it to be.