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?
