How to do Rank If like formula on data set


I want to make a formula that ranks data based on a sub-category in the dataset.
In my example I want to rank drivers by the fastest per team in F1 data.

Primary data is Team Name, Driver name and a position.
I want to rank each driver per team after which achieves the highest position.

Hi @simonpaaskesen,

Use the “Running total” action in the Rank mode. In the action specify grouping by “Team name” to calculate ranks inside teams.