I have a table as below
Customer
Customer | Manager | Assigned to | Is lead |
Customer A | John Smith | Jack Dole | Yes |
Customer A | Henry Kromer | Gina May | |
Customer A | John Smith | Donna Kole | |
Customer B | Henry Kromer | Gina May | Yes |
Customer B | Syd Barret | Joe Mancini | |
I have a slicer that people can select from Customer and Manager and Assigned to
Now I would like to have a table to show the list of Assigned to when I select a customer even through the Manager and Assign to is selected in the slicer. As an example
Slicer 1 Customer A Slicer 2: Manager John Smith
But the table would show this
Assign to | Is Lead |
Jack Dole | Yes |
Gina May | |
Donna Kole | |
| |
There are other charts that are being sliced according to the slicers but I would like to see how I can bypass the slicers for that specific table per customer. Basically all managers want to see who is assigned to what customer.
