3 Replies Latest reply on Feb 9, 2017 12:07 AM by Mohammed Ali Hussain

    Comparative ranks - for two diff periods(monthly/yearly) based on total sale

    Mohammed Ali Hussain

      Hi there,

       

      I'm trying to create a text table with following columns

       

      1. Date

      2. Customer ID

      3. Total annual Sale per customer

      4. Ranks1

      5. Ranks2

       

      I have sales data for two years and willing to have two rank columns, with an intension to compare the customer's rank in current and previous period.

       

      I have attached the data I'm struggling with, will be very grateful if someone can help me to achieve my goal.

       

      With many thanks and kind regards,

      Ali Hussain