On your "Sales Crosstab" sheet, just remove the the parent dimensions from the hierarchy from the rows shelf. The filter action will properly filter, but won't show all the unwanted headers.
See attached twbx.
Sales.twbx 204.8 KB
This post might be exactly what you are looking for.
I have the opposite issue. I need to have the user select the hierarchy level and then I need to show the selected hierarchy level and all child levels And mirror across multiple worksheets.