The data in a BI report can be Sorted using the Values/Measures selected.

Select the Sort Data icon from the BI ribbon

You can either sort the data on the Rows or on the Columns.

Click ‘Select’ and choose from the available Measures that have been added to the Report Layout.

You can then choose whether to Sort in Ascending or Descending order.

Finally decide whether to ‘Preserve Peer Grouping’.

Preserve Peer Grouping

This is useful if the report has nested dimensions on the area that is being sorted (i.e.Row or Column). Selecting this option means the sort will be applied to the second level whilst keeping the first level in order.

E.g. If you have Product Groups and Stock Items on the Rows of a report. The Stock Items will be sorted for each Product Group.

Advertisements