1 Reply Latest reply on Dec 2, 2013 10:53 AM by Tracy Rodgers

    Changing rank order

    Piotr Wodkiewicz

      I am trying to exclude Comp X from the ranking but keep it still in the list to have shares properly calculated (Simple exclude will not work). I thought of placing it low in the ranking list so they will not show in their normal place.

      I thought of formula IF ATTR([Vendor])="Comp X" THEN 50 ELSE INDEX() END which makes Comp X display rank 50 but this is not taken into account with other companies. As you can see the list goes from 1-5 and then start with 7. While I want Comp 5 to show as rank 6 and so on.

      Is there a way to fix this?