Pivot table allows you to set the specific sort order (Ascending, Descending and Datasource order) for members in columns and rows. By default, members can be sorted alphabetically. This feature allows the user to redefine its own order for specific members which are in columns/rows along with the default sort orders.
Example scenario: You can define the custom order for “Bikes”. If you set the sort order as ascending for the DataSource => “Vans”, “Cars”, “Bikes”, “Autos”, the result will be => “Autos”, “Cars”, “Vans”, Bikes