2 Replies Latest reply: Jul 28, 2017 2:56 AM by Chun Fung Cheung RSS

    Divided into 10% Group by Ranking

    Chun Fung Cheung

      I have two column of data, which are "Customer ID" and "Transaction Amount".

      Capture.PNG

      And we decide to divided those customer into 10% group (it should be 2 customers each group for this sample data) by ranking their transaction amount.

       

      Should we have any methods to divided those customer into the follow result:

      Capture2.PNG         Capture3.PNG