3 Replies Latest reply: Apr 22, 2013 3:29 AM by Rahul Lakhina RSS

    Help with Ranking Multiple Expressions

    Rahul Lakhina

      Hi,

       

      I need help with ranking multiple expressions in a pivot
      table with on dimension.  Currently my
      table looks like below:

       

       




       
       
       
       
       
       
       
       
       
       
       
       


       





       

       

      What I need is the focus area for each row where development
      = “Yes” to give me the header for the lowest score in Column range 2 to 6. Is
      this possible?

       

       

      Regards

       

       

      RL

        • Re: Help with Ranking Multiple Expressions
          Rahul Lakhina

          I am trying to use some thing like:

           

          if(Column(7)='Yes', If

          (Column(2)<Column(3) and Column(2)< Column(4) and Column(2)< Column(5),vRank1,1))

           

          vRank1 = 'Add Product'

           

          However it falls appart because of the '-'. Any suggestions please?

           

          Regards R

            • Re: Help with Ranking Multiple Expressions
              Gysbert Wassenaar

              Try using the rangemin function:

               

              If( Column(7)='Yes',

                   if( rangemin(Column(2), Column(3),..etc ) = Column2, '% tNPS (overall)',

                   if( rangemin(Column(2), Column(3),..etc ) = Column3, 'Add Product',

                   ...etc

                   if( rangemin(Column(2), Column(3),..etc ) = Column6, 'NUC') ))))))

               

              And make sure all the parentheses match up

                • Re: Help with Ranking Multiple Expressions
                  Rahul Lakhina

                  Thank you Gysbert, it worked with a slight tweek

                   

                  Used the following to counter the '-':

                   

                  IF

                  (Column(7)='Yes',


                  if

                  (RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))=  num(Column(2)),vRank1,


                  if

                  (RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))=  num(Column(3)),vRank2,


                  if

                  (RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))=  num(Column(4)),vRank3,


                  if

                  (RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))=  num(Column(5)),vRank4,


                  if

                  (RangeMax(num(Column(2)),num(Column(3)),num(Column(4)),num(Column(5)),num(Column(6)))=  num(Column(6)),vRank5))))))

                  Regards Rahul