Set analysis is being ignored when using the RANK function
I'm using a piece of script that counts the number of employee names that have a RANK between 0 and .10 when the Manager Type = 'IP'. The script is counting correctly. However, when the user selects a Manager Type other than 'IP', the chart displays all zeros. The appropriate behavior is to always display data for Manager Type = 'IP' regardless of what manager type is selected from the filter. A few of has have looked at this, but we haven't figured out what's missing.