SOLVED Create variables for each unique value in a field
I'm trying to create a variable for each quarter ([Incident Quarter]) in a table (Incidents). For example, the most recent quarter would be $curr_Quarter, the previous quarter would be $curr_Quarter_min1, and $curr_Quarter_min2, etc. Any suggestions are welcomed. Thanks in advance!
Thanks @stevejoyce . I think that'll help me get more than half way there! The number of quarters in the data set can vary so I want to keep the number of variables that I create dynamic. Would I need to first get the number of unique values, and write a loop to create the variables with the max function?