Summing Multiple Visual Slicers

[Anonymous]

I'm not sure this is possible and am open to other solutions.......but I am trying to make a report that allows management to select how many people will work on each of our programs. I have how each of those decisions will affect the goals of each team. (Example: If you put 3 people on Program A, you will meet all goals but if you drop it to 2 people, you will only hit 2 of 3 goals.) Because of this, I have to have all the program's data on different tabs and have a different slicer for each program (as the number of employees on one program will not effect the goals of a different program.) What I need to accomplish (and can't figure out how) is to notify management when they have "placed" all employees with a program. Ideally, I want to just sum the number selected on each of my slicers and have something turn green when they all sum to 52 employees. But I can't find a way to sum the number selected in a slicer. Again, I'm open to any solution that will quickly show they have accounted for all employees without counting too many. Thanks! 

[Greg_Deckler · Accepted solution]

You should be able to use MAX or SELECTEDVALUE to get the number out of each slicer.

[Anonymous]

I was able to use SELECTEDVALUE and just add them all together. This is PERFECT!!!! Thank you!!!

[Anonymous]

I’ve never used those before. Can you provide an example?