To clarify --
Is the fourth column you described something you need to actually have in the report?
Or did you describe it as a means to "...'group' the reasons by number in order by the priority across the page"?
If it's the latter, you might not need the fourth column and may just follow the Priority values - the current Priority values seem to have the same "weight" as the fourth column you described.
If this is the case, you could do either of the following:
- in Table view, create a Sort using the Number and Priority fields with the Order set to Ascending
- or you could create a Summary with the Number and Priority columns as Key fields, then put in the Reason as the Item field. You might want to set the Key Values to Suppress duplicates for the Number field, so that the Number value doesn't keep repeating in the display.
However, if you need to actually produce/generate the fourth column you described, you'd need scripting and/or Automator.
Hope this helps.
What I need is when that first number changes I need a fourth column to start numbering again at '1'.
I will then export the table to Access and split the values row by row by that fourth column 'give me all the ones here' 'give me all the twos here'. Then end up stringing them across the page linking on the number in column 1.
either a summary or something that will group by that first column number with the 'reasons' across the page in 'priority order'
a new column that numbers sequentially starting at 1 and restarting at 1 each time the number in the first column changes.
Thank you so much for the input and response to my question. I had been out of the office for a bit and didn't have an opportunity to reply.
In the mean time a solution has been found by Olly B. - Monarch Experts. Just two models. One to assign record numbers and one to group by that first number row and stringing with calculated fields. It solved the issue for us.
I absolutely love the Monarch product. It has come to the rescue more times than I can count.
Thank you again for your time and answers to my question. I appreciate it.