M
Mark A
Hi, I have a "Risk Report" that I need to sort in the order of importance of
the risk. Risks are rated by two fields:
Field 1: RAG Status (possible values of): "Red", "Amber", "Green"
Field 2: Impact (possible values of): "High", "Medium", "Low"
So I need the "Red, High" Risks to appear first, then the "Red, Medium",
"Red, Low", "Amber, High", "Amber, Medium"
Obviously the sort alphabetically either ascending or descending won't
achieve this. How can I achieve this sort order? The "Prefix Characters"
option in the "Sorting and Grouping" BOx sounds promising but I cannot find
any help files on it.
Thanks, Mark
the risk. Risks are rated by two fields:
Field 1: RAG Status (possible values of): "Red", "Amber", "Green"
Field 2: Impact (possible values of): "High", "Medium", "Low"
So I need the "Red, High" Risks to appear first, then the "Red, Medium",
"Red, Low", "Amber, High", "Amber, Medium"
Obviously the sort alphabetically either ascending or descending won't
achieve this. How can I achieve this sort order? The "Prefix Characters"
option in the "Sorting and Grouping" BOx sounds promising but I cannot find
any help files on it.
Thanks, Mark