I want to be able to filter for assignees (and reporters) of the chances and risks. Is there any way to reduce the Pages-dropdown of “All Assignees” and “All Reporters” to values that are available in the report?
At the moment all users are shown in the dropdown. My goal is, that only users are shown that have at least one item in the matrix they are responsible for. That way it would be much easier to filter for relevant issues.
That will check the previously selected dimension members and drop the remaining members with no value for the measures. However, if the dimension members have historical values for the dimension combinations - they might still be retained.