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.

...