How to use the MAX formula for the below mention scenario (MAX(SELECT(Responses[Tran], ([REGION]&(MONTH([TIMESTAMP]))&(year([TIMESTAMP]))))+1
I would like a transaction number running for each region independent of the other regions. Example: AZ gets a call and transaction #1, then #2 for the second call and so on during the month, perhaps ending with the last call of the month (#95). While CTX has #1, then #2, until the last call, perhaps being #32. No longer utilizing the perpetual counter that we are using now.