Hi @rippes, The best way to resolve your post on the community is to locate the reply that worked for you and click "mark as solution". For the future, you can keep your original posting so that future community members with your same problem can benefit from your resolution! Also I would greatly appreciate if you marked my post as a solution 🙂 solutions are incentive for community members to keep helping

If you want to show only the very top product by store, use the sample tool for this. Like I mentioned above, sort your results and then sample the "First n" and set n=1, grouped by store.