11-20-2018 11:52 AM
I have been looking for an answer to this question all over. I have a very large data set that rolls up to 5 different Sales Directors. The slicer selections help navigate through all of the pages and visualizations for each Sales Director, but what I need is the ability for the Select All function of the slicer to sum all of their revenues, targets, rankings, basically every measure I have broken out at the SD level I need at a total region level. Can anyone offer any advice?
11-20-2018 11:40 PM
The requirement is not very clear. Share a complete exmaple if possible.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
12-12-2018 07:31 AM
Hope this helps. This is the net revenue delivery by one of our Sales Directors. You can see the actual amount, goal amount, and gain or gap. In the second photo you can see I've selected two Sales Directors and instead of summing the two totals together and showing 700 million, it only shows the most recently selected SD's number. Do you know how to fix this? I want to be able to select all SD's and get a total region number.