1 Reply Latest reply: Apr 6, 2016 2:27 AM by Stefan Wühl RSS

    I need a Rank by Month/Product

    Ciro ORIC

      Hi there!


      I have the following data serie:


      Month  Product Sales

      jan/16   Apple        10

      jan/16   Orange       5

      jan/16   Apple         1

      feb/16   Orange       5

      feb/16   Apple         2


      I need to create the following table:

      Month  Product  Month Sales  Rank of Sales

      jan/16   Apple          11                       1

      jan/16   Orange         5                       2

      feb/16    Orange        6                       1

      feb/16    Apple          2                       2


      I have no idea about how to write the rank of sales formula. Could you please, help me?


      Many thanks for any kind of help.


      Best ragards,