Creating a Top Ten List in Filemaker

[Dean Redding]

Hi All,

I am struggling to figure this one out.

I have created a summary of sales for each year.

I have sorted them descending to show the customer with the highest sales to the lowest.

What I am trying to do now is place a number next to the customer to know where that customer came for that year.

Eg.

2008

1. ABC - $45,000

2. FGE - $43,000

3. DGH - $30,000

2007

1. FGE - $75,000

2. DGH -$50,000

3. ABC - $45,000

Any help would be great, thank you.

Dean

[comment]

Assuming this is a report sub-summarized by year, try a summary field defined as Count of , running, restart when sorted by year.

[Dean Redding]

It worked a treat!

Thank you.

I have looked everywhere for this solution.