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,

       

      Ciro