Advanced List That Shows Candidate's School Division

My school has two campuses. Blackbaud Enrollment Management uses 'School Division' for the campus name along with 'Entering Grade'. This permits reports to show School A - Grade 2 versus School B - Grade 2. If you just filter for Grade 2, you get a mix of schools.

I have an advanced list that is filtering all users with the Candidate role. It permits me to show Entering Year and Entering Grade, but when it spits out Grade 2, I cannot distinguish to between campus. How do I include 'School Division' in my advanced list? Or is there some other way to distinguish my enrollment counts by campus. I know SKY reports include it, and my Capacity Planning dashboard also does it, but I have an automation workflow that must use an Advanced List.

For those with the Student role, I have no problem including School Division, but for candidates, I cannot report accurately.

Thanks!