I would do something along these lines.
And then calculate your ratio from those.
This should allow you to see the ratio over whichever dimensions you'd like. Sample workbook is attached.
Hope this helps,
Retention Rate.twbx 10.9 KB
Thank you for your reply. Total Enrolled is total enrollment(total number of students).
In that sense, the results seems correct?
If the issue is solved, could you mark either of the answer as correct to close the thread, not from inbox view but from original post.
Thank you Jim. It works. Also I understand it well if I am dealing with categorical values in the data in future.
Thank you. This method works too.