Ultimate battle: XLOOKUP💥SELECT. Which one is going to win?🤔

To enhance the filtering process and provide an option to show all items, user can consider adding an “ALL” item to the dropdown list (this can be done via concatlist() or the generate items feature). When a user selects “ALL,” the entire table will be displayed. This approach may be more intuitive for users, as…

It is possible to reorder items based on values via script (an example shown below). It should be clear that in a sorted matrix, Quantrix sees only original (unsorted) item position (index). One can check it by adding item with #category formula in the sorted matrix. So, concept of sorting and reordering somehow different.