Hello Excel Experts,
This is my first time posting in the forum, so I hope that I did everything correctly. I have attached a workbook with sample data. I am working on a dashboard for management use. If hypothetically, I want to be able to see all sales by period and region, however Andrews, Thompson, and Smith left the company and I do now want their names available in the Rep slicer, is there any way to keep the sales data so it is complete and accurate, however remove their names from the Rep slicer since we are no longer reporting on their performance?
Bookmarks