The Crosstab has numerous functions for rows, columns, fields, and measures. This article explains all of these different functions to ensure that Crosstab displays your data in the desired way.



Rows



1) Delete Row Summary - This will remove the totals or subtotals from the Row Layout

2) Expand Members - This will show the details of that row

3) Collapse Members - This will only show a summary version of that row with its totals

4) Remove from Crosstab - This will remove the field or measure from the Crosstab

5) Switch to Column Group - This will move the field or measure to the Column Layout

6) Create Filter - This will enable a filter to be created for this field or measure

7) Sort Ascending - This will organize the information either alphabetically or numerically first to last, depending on the entry type

8) Sort Descending - This will organize the information either alphabetically or numerically last to first, depending on the entry type

9) Don't Sort - This will display no additional functions for this row. If a function was already selected, this option will reset that row's function 

10) Move Right - This will move this row right one over. Depending on the Location of a row, this option might also include 'Move Left', which would move this row left one over



Columns


Fields and Measures have their own unique functions while in the Columns Layout. Both sets of functions are described below.



Fields



1) Keep Only - This will remove all other rows that are not 'Totals' or named the same as the selected row

2) Exclude - This will remove this row from the Crosstab

3) Sort Ascending - This will organize the information either alphabetically or numerically first to last, depending on the entry type

4) Sort Descending - This will organize the information either alphabetically or numerically last to first, depending on the entry type

5) Don't Sort - This will display no additional functions for this row. If a function was already selected, this option will reset that row's function 

6) Filter Top N Values - This will filter for a chosen number of top values

7) Filter Bottom N Values - This will filter for a chosen number of low values

8) Don't Filter Values - This will display no filters for values in the Crosstab. If a filter was previously selected, this option will reset that column's filters



Measures



1) Change Summary Calculation - This will change the calculation displayed. Depending on the measure, some display more options than others. Options include Average, Maximum, Minimum, and Sum, among others

2) Change Time Balance Calculation - This will update the Time Balance Calculation. While options are available, run reports on the defaulted option of 'Time Balance Default' for best results

3) Change Data Format - This will change the numerical format displayed

4) Remove from Crosstab - This will remove the measure from the Crosstab

5) Move Right - This will move this column right one over. Depending on the Location of a row, this option might also include 'Move Left', which would move this column left one over