2 Replies Latest reply on Mar 27, 2017 7:49 PM by stevem

    generate rank field in a report

    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