Let’s assume that we have:
In such situation, we can do the following:
To compute the above aggregate, we only need to sort a table with the A and B columns only (and not the whole table, with all the columns). Thus, before the Sort Action, it’s interesting to place a ColumnFilter Action. To have the highest computation speed, you should always reduce to the minimum the volume of data to sort.