here im just created a pivot column offence by type by combining some columns and now I need to find the top 5 teams based on the number of public disorder offence. But while getting the total number of public disorder offence im just added the type of offence to the filter and selected the public disorder one but how can i do that in the top filter for the team.
1 answer
Good morning -
see https://jimdehner.com/2021/10/04/sets-and-filters-the-condition-and-top-n-tabs-what-do-they-do/ it will explain how to use Top N filters and how to combine them with other conditions
