Use this Calc:
drag to filter
This would filter view without filtering data
Goal is to remove the Level 3 consultant data without impacting the Level 2 Managers. That equation when I placed 'Report Title' where you wrote "Your Value" and then selected exclude consultant, it still removed that VP Finance.
Time For a workbook with fake data.
Posted. I want to remove the people under B and E without removing the B and E columns. Remember in the real workbook, "Show Empty Columns" does not work because it shows everyone and not just supervisor A.