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.
The index function is dependent on how the view is set up. It does not know to change the order based on the calculation above. The best option would be to sort Vendor so that Comp X is at the bottom of the sort.