Sum value per different line

Hi guys, I have a situation like this.
In a table I have, line per line, every driver results, and they are repeated, for example:
Driver 1 | 1st
Driver 2 | 2nd
Driver 3 | 1st
Driver 1 | 2nd
Driver 1 | 1st
Driver 4 | 3rd
Driver 2 | 2nd

Ok…I want to create a counter to show in the app, with the sum, driver per driver, about their podium finish, like this:
Driver 1
1st place: 2
2nd place: 1
3rd place: x

Driver 2
1st place:…
2nd place…

You can create a query column for each podium position… so 3 columns… and then use 3 rollup columns to count the entries in each of those columns…

Your query columns will match the Driver Name to “this row” driver name and position equals 1st, 2nd, 3rd

1 Like