I have a list of product SKUs and the revenue they generated in a certain period.
The list of SKUs is really long, so I’d like to able to filter to a specific SKU within that list and return the surrounding 10 products (5 above and 5 below) when ranked by revenue.
The user would filter the SKU to
30010492910, and the Look would return 11 rows, with the filtered SKU in the middle, ranked by revenue. Displaying the rank would be ideal.
Here’s an example of the expected output (with fewer rows):
Any idea how to accomplish this?