You can do this on a Summary report but no (or not easily) as actual field... make a formula numeric field with a formula value of 1,
called [Rank].
Make summary report and group it how you like, but ensure that every record is on its own line,.
for example group by Primary code, and then by Secondary code and then by project name. Include the [rank] field on the report but show as a running total down the column.
The sort will probably work correctly if the Primary code if form a simple multiple cice field set to sort n the correct order. Or else you will need to introduce a new formula field or lookup field off the benefit categories table to force the correct Alpha sort, such as
1. High Benefit
2. Meduim Benefit
3. Low Benefit.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com
------------------------------