COPA Reports - Drilling down in a field used as a selection

[Former Member]

We have standard KPA reports that are sent out to business users regularly as PDF email attachments, and these are good, but our users are looking for more functionality.

We have also developed a set of CO-PA reports in KE30 that allow users to take advantage of the drill-down functionality. We would like to give the users of the KPA reports this functionality, but there are issues with the way some users need to select data.

Here is one example

Users would need to select a range of one field or another (Sales District in this example), to get the data that is pertinent to them. But, once the report is run, they cannot use the Sales District field to drill down to in the "Navigation" pane:

I have considered adding a copy of each and every field that a user might want to use as a drill-down field (one for selection and one for drill-down), but this will clutter up the Navigation pane and will confuse many users as to why there are duplicates.

What are my options?