here is one way
on the first sheet set up a filter on the vendor (customer in my example)
make a copy of the vendor (customer)
then on the first sheet apply the filter on customer to a second sheet
on a second sheet add the vendor and the vendor copy to the sheet
add a filter for the copy with only relevant values option
on the original vendor - open the pill and unselect show header to hide the column
and the sheet will look like this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
2 level filter .twbx 1.2 MB
That did the trick, thanks Jim!
have a good weekend