2 Replies Latest reply on Aug 5, 2016 2:55 AM by Vasil Petkov

    Ranking multiple dimensions

    Tim Lang

      I have several dimensions that can each have the value "Y" or "N". I've attached an example file.

       

      I am able to calculate the percentage of "Y"s for each dimension:

      ...and I would now like to rank the resultant percentages against each other.

       

      The result I'm after should look something like this:

      Dimension----PctY-------Rank

      Choose3------56.25%----1

      Choose1------50.60%----2

      Choose2------47.78%----3

       

      How might I go about this?

       

      Many thanks in advance!