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.