I have a Slicer for a report that contains Employees in a Department, my Employees are defined in a table in my ERP system (SQL DB).
We gain and lose employees, and they move between departments on a fairly regular basis.
Is it possible to tie the Content of the Slicer for Department to the Employee Table in my SQL Table?
Or am I doomed to do busy work and update the Slicers manually every time an Employee has a change?
Example:
Panel Saws: Susan, Billy, Martin
Shipping: George, Mark, John
Mark moves to Panel Saws, and we hire Chris for Shipping.
Panel Saws: Susan, Billy, Martin, Mark
Shipping: George, John, Chris
Ideally the Report Slicer would be updated and the Report would show only the employees in the respective departments, without having to redefine the Contents each time.
