AnsweredAssumed Answered

Numbering rows in a report

Question asked by FileMakerNovice on Feb 16, 2012
Latest reply on Feb 16, 2012 by FileMakerNovice

Title

Numbering rows in a report

Post

Hello,

I am wanting to number the rows in my report.  I have a database that has locations and people in each location.  These people are ranked.  The report so far shows a sorted list, first by location, then by person.  Is there a simple way to number the people in each location 1 to x or is a new variable needed to loop through the database needed?

To simplify database, say there is just one table called sales people.  There are three fields: name, location, score.  I want the report to have everyone from location A like this:


Location A
1. Person 1
2. Person 2
3. Etc
Location B
1. Person 1
2. Person 2
3. Etc

Outcomes