I have created a subsummary report that ranks items by total sold. The total sold is the summary field. I would like to add the rank number to the report, but cannot use the record number since each item has many sales records.Is there some way to add the rank number? It is a running count of the subsummary part.

See:

http://fmforums.com/forum/topic/61158-number-of-employees-from-payroll-report/page__p__289204#entry289204

Note:

1. In your case, you should select the 'Running total' option for the sCountEmployees field.

2. This will return "a running count of the subsummary part", which is not exactly the same as "the rank number". The difference will be apparent in case of a tie.

Thanks, I'm usng that technique to get the unique item count for a subsummary field elsewhere but using a running total should give me what I need for this. I'm not worried about ties and would just give separate ranks anyway.

Thanks a lot.