TOP 20 per Location
I want to create a table with top 20 highest open amount of open order per location.
So location 1 followed by 20 orders, location 2 followed by 20 orders and so on
I tried with the rank function (rankdesc(d-1, all, m1)), but then I get a rank displayed without considering the different locations.
The top-list function gives the same result without taking into account the different locations.
Does anyone know how I can fix this?