16 Replies Latest reply: Jun 15, 2018 2:56 PM by Sunny Talwar RSS

    Alternate State Set Analysis Help

    Jordan Erisman

      Hey everyone,

       

      I am dealing with an issue I cant quite figure out. I have 2 alternate states (State1, State2) and I want to to find the rank with the values of State1, including the aggregated average from State2. See example below:

       

      State 1:

      IdValue
      110
      211
      312
      414
      515

       

      State 2:

      IdValue
      612
      713
      814

       

      Result:

      IdValueRank
      1106
      2115
      3124
      State 2133
      4142
      5151