Hi,
I have a problem with listbox.
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.
Any suggestions?