I have appended two data sets into a Master data set in order to create a report showing the support ratio of FTEs per end user device.  One data set contains device counts at each of our locations, the other contains all budgeted FTEs per location.  Then I inserted a formula to calculate the ratios and inserted it into the report, which is working correctly. 

The problem I'm now having is the requester wants the ability to exclude certain job titles using a compact slicer and have it recalculate the ratios based on the titles selected. Since the device count data set does not have a title field, if you select a title in the slicer, it removes the device counts and the ratios reset to 0. 

I was thinking that if I insert a title field into the device counts data set and include all titles from the FTE file for each device, that the device counts will not be removed no matter which title is selected, but I'm not sure how to assign more than one title to each device.  Does anyone have any ideas?