You need a quick table calculation for this.
Then select relative to first, which is a helper calculation you can insert into the table calculation. Sorting is important, as this marks the first position in the table which is yours and your competitors follow.
After that you can drag this calculation into a new field which will serve as to colour code.
Please find attached the workbook with the solution. Let me know if this helped.
Table calc use case.twbx 921.5 KB
Thanks so much!! That works amazingly well