AnsweredAssumed Answered

generate rank field in a report

Question asked by stevem on Mar 27, 2017
Latest reply on Mar 27, 2017 by stevem

Hi
I have a database of items and how many units sold:
ITEM         UNITS
Item A       15
Item B       19
Item C       21

I have created a report layout which sorts the items based on units sold:
ITEM         UNITS
Item C       21
Item B       19
Item A       15


Is there a way that the report can generate a “rank” field so that the report will look this this:
RNK  ITEM         UNITS
1    Item C       21
2    Item B       19
3    Item A       15


I use FileMaker Pro 12 Advanced
Thanks

Outcomes