I'm not sure what post you were looking at, but I was able to use RANK to solve the problem. Steps are as follows: (1) Create two new line items in TAT_HRApplications: Start Date of Month, Rank Grouping. (2) Start Date of Month will be a Date-formatted line item with the formula START(ITEM(Time)). This will create a tie on transaction rows for a given month and applicant, allowing for a ranking based on a sequential tie-breaker. (3) Rank Grouping will be a List-formatted line item (where the List is your Applicants, shown in the source module's page selector) with the formula ITEM(*insert name of Applicants List here*). This will be used to "restart" the ranking for every applicant. (4) In your transaction count line item, enter the formula RANK(Start Date of Month, ASCENDING, SEQUENTIAL, TRUE, Rank Grouping). The second argument is arbitrary. (5) Map transaction count to your target module's list upon import. Best practices tips: (1) The two new line items can be pared down to their respective dimensions (Start Date of Month only applies to Time, and Rank Grouping only applies to Applicants List) to reduce module size. (2) If these calculations have the potential to be used in other modules, I suggest splitting these out into modules and referencing them in your Applicants Module to avoid cluttering one module with multiple subsidiary views. From my understanding, subsidiary views decrease model performance (not to be confused with model size). Let me know if this works for you.
... View more
