0 Replies Latest reply: Mar 3, 2016 11:12 PM by Dingyong Huang RSS

    Nested loop for grading

    Dingyong Huang

      Hi

       

      I have the attached data - basically its sales data for 300 salesman in 3 regions for 3 different years.

       

      Based on the combined sales figures for all 3 years, I would like to grade the salesmen's performance, first, based on their usa sales, into 5 grades (using fractile).

       

      Then, based on those salesmen that are graded 1 for their usa sales, grade them again based on their asia sales figures (also into 5 categories using fractile).

       

      Then, based on those salesmen that are graded 1 for their usa sales and graded 1 for their asia sales, grade them again based on their europe sales (also into 5 categories using fractile).

       

      Repeat for those that are graded 2 for their usa sales and so on...

       

      After the evaluation, sum all of the grades to produce an overall score. The model structure and envisioned result are as attached.

       

      I have a feeling that it requires a nested loop but have no idea how to do it.

       

      Can anyone help? I'm using a personal edition so I would appreciate if you could show the load script here.

       

      Thanks!!