11 Replies Latest reply: Jun 5, 2013 12:10 PM by Steve Zagzebski RSS

    Set analysis - counting distinct

    Steve Zagzebski

      I am looking for set analysis help on the data below. Basically I need to count distinct groups that had less revenue in the current month than in the previous month. (in the example below group 3 and 5 had less revenue in the current month than the previous).

       

       

      DATA:
      DIVISIONGROUPYEARMONTHREVENUE
      A120130190
      A1201302100
      A2201301110
      A2201302120
      A3201301150
      A3201302100
      B4201301100
      B4201302125
      B5201301140
      B5201302100
      RESULT:
      DivisionYEARMONTH% of Groups with Less Revenue then Prior Month
      A20130233%
      B20130250%