Using a variable for sorting

This example is based on the Samples application, which can be enabled in on-premises environments. It uses a hyperblock created from the Product dimension.
  1. Create a global variable named gv_SortingASCDESC and set its value to DESC.
  2. Select the hyperblock and click New Sorting Criterion in the Sorting pane of the List Designer.
  3. In Sorting Criteria Settings, select Type > Unique name.
  4. Select Order > <Edit Formula>.
  5. Double-click gv_SortingASCDESC in the list of global variables and click OK.
    In View mode, the elements of the Product list are sorted in descending order. Change the value of the variable to ASC to display the list in ascending order.