Calculate a rank for a particular value in the table, in this example, the brand Cencora, across the columns. The workaround is using R CODE.