I would like to calculate how many students in a given fiscal have been a student in a previous fiscal year. I want to only count those with a Active (A) status but I seem to be considering each status when counting the programs of an individual student.
Can someone help me? I want to show how many repeat learners in 2016, 2017, 2018.
Thanks for any help you can provide. I have attached my workbook. It is the "unique Learners" sheet.