Situation: I have a field with 10 distinct products with numberOfOrders, and One table with with list of products, which user have to see.
I need to show top5 products by numberOfOrders PLUS those products from other table.
Product 1
10
User1
Product 5
Product 2
33
User1
Product 6
Product 3
39
User1
Product 2
Product 4
34
Product 5
7
Product 6
38
Product 7
9
Product 8
21
Product 9
2
Product 10
21
If I want to show only ranked products I use if(aggr(rank(sum(NumOfOrders),4),Product)<=5,Product. If I want to show only User's specific products, I use if(Product=[User's product], Product).
But I don't find the way how to merge those lists.