Properties Menu - Sorting

In Vitara Grid chart with just a click on the header of a column, we can sort the data in that column. For the first click on the column header, representing the column is sorted into ascending order. See the screenshot below which is in Ascending order.

sorting 1

If we want to sort the column in descending order, click a second time on the column header. representing the column is sorted in descending order.

sorting 2

Sorting can be removed by clicking on the column header for the third time. We can also sort multiple columns by holding the ‘shift’ button on your keyboard click on all the column headers which you want to sort.

Advanced Sorting

Advance sorting will allow users to do different sorting on different grouping levels. By this, you can easily sort the columns in your required order. The Property editor has an option of Sorting. See the below-representing sorting option in 2 different ways.

Advanced Sorting using Edit Option

From the Property Editor, click the Sorting tab. The first one square button shows the metrics you want to sort and the second one shows the order what you want to sort. See the screenshot below.

sorting using edit button

Advanced Sorting using the Hamburger option

From the Hamburger menu, Select any metric, select Advanced Sorting and click on Manage Sorting, it will take you to the Editor tab. See the screenshot below.

sorting using hamburger

Advanced Sorting on Grouping Level

Advanced Sorting can be applied on grouping levels too. Now, once grouping is applied in the grid, there is a button added in the property editor. See the screenshot below where the Sorting is applied on a discount on a product category level.

sorting grouping