Page Comparison

...

To sort in the crosstab view, perform the following steps: 

1. From the Toolbox, select Workbooks, then select a workbook and worksheet.

2. Confirm that the view type is set to Crosstab.

   

3. Do one of the following:

   1. Right-click the heading of the first column and choose Sort to show sort order and sort by options.
      You can sort alphabetically or within a hierarchy and choose the sort direction as ascending or descending.

      

   2. Right-click the heading of the first column and choose TopN to view the top or bottom N values for that item.
      See Filtering using TopN or BottomN for details about using TopN.

   3. Right-click the heading of any column to set up options to sort by that field or the alignment options for that field.

   4. Right-click the heading of the first column and choose to show all members or delete a dimension, measure, hierarchy, or attributes.
      You are not prompted to confirm.

   5. Right-click the heading of the first column and choose Show on Tooltip and select Members only or Members with hierarchy.
      Depending on the data you are viewing, the results and sort options available to you may vary.

      

To sort worksheet data, perform the following steps.

1. From the Toolbox, select Workbooks, then select a workbook and worksheet.

2. In the Filter pane, under Dimensions, click the value filter. The list dialog is displayed.

3. Click the Sort option to sort the list. You can use the Sort order option.

4. In the Sort Order option, you can use the default,

Image Added