Page builders can sort data in a custom view to display values in columns and rows by ascending or descending order.

On a grid with nested dimensions, you can only sort child items. Parent items contain multiple child items and can't be sorted.

You can set the sort for a grid on a custom view. You can't customize Module views.

You can only sort custom views when you edit or design a custom view. Make sure that you're in the Select primary grid or Card configuration panel dialog before you begin.

If you sort a grid as you design your view, you can make sure your users can find the data they need. 

Users can also sort a grid, once published. If they later unsort the grid, the data reverts to the order you set.

You can create custom views from grid cards, KPI cards, chart cards, and the main grid of a worksheet. 

KPI cards always display the top-left cell of a grid. You can sort the custom view used by a KPI card to ensure the highest or lowest value in a row or column displays in the top-left cell, and on the card.

When you apply a sort to a row or column that's an axis on a chart card, the order of values on the axis changes.

Sort data in a custom view

To sort data in a custom view:  

  1. Select Configure on a new card, or hover over your card and select Edit . 
  2. On the Overview tab of the Card configuration panel, select View. 
  3. On the Custom views tab of the Select data source panel, choose a custom view.  
  4. On the preview, select the row or column header you want to sort the data for.  
  5. Select Sort , then choose Sort ascending or Sort descending . 
  6. Select Update. 
  7. You can configure your card.  

Unsort or change sort

To reset your grid to its original order or change how data’s sorted:  

  1. Select the row or column header you want to unsort.
    An arrow displays in the header to show the sort order.
  2. Right-click, and select Sort <icon>, then choose: 
    • Unsorted to reset your grid.
    • Sort ascending .
    • Sort descending .

To reset all cards on your page to the default options set by the page builder, select Page options > Reset page. On the Reset this page? dialog, select Reset.