Filter children excluding top summary rows
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.
Best Answer
-
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.
Answers
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!