Sort in tasks

Both Show Top or Bottom Rows and Window Function depend on the sort to determine the correct result. If no sort is provided, a default sort is assumed which is the order of the data in the view. This is the same as order in which you see data in the grid if there is no sort has been applied on the data view.

If you perform operations like filter and join, the data might not be in the same order as dataset. Hence it is recommended to set a sort explicitly on these tasks to prevent any undesirable outcomes.

The sort menu will appear as a sub-menu in these tasks’ menus. You can specify one or more columns to sort by. The additional columns will be used to break the tie if the first column being used sort by is not able to resolve the order of any two rows.

A column can be sorted either in the ascending order or the descending order.