Hello,
This is a small part of my table.
As seen, there are three main rows which need to be filtered based on software level.
Below each row, there are some specific activities, output and control categories.
The filtering options as of now are 1) A, B, C, D 2) A, B, C and 3) blank
I grouped rows 14 to 17.
Whatever filter I choose, the row 14 to 17 is visible.
I want rows 14 to 17 to be visible only when row 13 is visible via filtering.
The same goes for rows 4-7 with row 1 and rows 10-11 with row 9
Help would be much appreciated.
Thanks
This is a small part of my table.
As seen, there are three main rows which need to be filtered based on software level.
Below each row, there are some specific activities, output and control categories.
The filtering options as of now are 1) A, B, C, D 2) A, B, C and 3) blank
I grouped rows 14 to 17.
Whatever filter I choose, the row 14 to 17 is visible.
I want rows 14 to 17 to be visible only when row 13 is visible via filtering.
The same goes for rows 4-7 with row 1 and rows 10-11 with row 9
Help would be much appreciated.
Thanks