Page Comparison

...

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 datadimension members in filter listing, 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 sort order. You can also use specific sort order for:

   1. Date: Use the Oldest on top or newest on top option.

   2. Numeric order: Use the smallest on top or largest on top option

   3. Alphabetic order: Use the A to Z or Z to A option.

...