On many of our Sales Dashboards we have a dashboard filter that has all of our Account Executives/Managers names listed that have worked at our company throughout its history. I am looking for a way to implement a background filter within the main 'Acct Exec. Name' filter to only show Account Executives that are still active or working at our company. Currently, the background filter tool lets you do that, but when I filter out the people that are no longer working at our company, it will then skew and erase the historical data. So I only want to see the active Account Executives in the filter, but still keep the historical data from all the older account executives. Any ideas on how to go about this?
Please sign in to leave a comment.