I have a situation where a student inquires in one period and ends up applying, being admitted and being enrolled in different dates that could be either in the same term or different term and even academic term. The problem is that if I use inquiry ( or any other date) date when I am comparing inquired, applied, admitted and enrolled data, numbers are different based on which date I am using. For example, if I take inquiry date, number will show number of applied, admitted and enrolled students based on inquired date but based on not respective dates. Therefore, I am trying to figure out how I can use a date that will have exact date numbers regardless of inquired, applied, admitted and enrolled dates. Thank you.
Can you attach workbook please?