How to use AOR subject area to show active AOR's for inactive assignments?

Summary:

Trying to get a list of inactive assignments with active AOR

Content (please ensure you mask any confidential information):

I'm trying to use the subject area "Workforce management - Areas of responsibility" to generate an analysis showing all inactive assignments that still have active AOR.

I've made columns for the the representatives assignment numbers and their assignment status type, but when I want to apply a filter to sort the ones with "Inactive" assignment status, I'm only able to choose "Active".

It seems the subject area only contains active assignments per default, so how can I create an analysis showing the active AOR's for inactive assignments?