Comparison Function

The Comparison Function dialog appears when you select the Comparison Function button in the the Crosstab Wizard, Insert Crosstab dialog, or Convert to Crosstab dialog, or in the Bind Data screen for crosstab in the Web Report Wizard. It helps you to add a comparison function as an aggregate field for a crosstab. See the dialog.

The following are details about options in the dialog:

Function

Specifies the function of the calculation: Percentage, Permillage, or Difference.

Comparison Function Spans on Row Direction

If checked, the comparison function will be placed into the column total cell of the crosstab.

Comparison Function Spans on Column Direction

If checked, the comparison function will be placed into the row total cell of the crosstab.

Break by

Items in the drop-down list vary with the position of the comparison function. It specifies the first parameter of the comparison function.

Refer to

Specifies the item as the other parameter of the comparison function.

Accepts all changes and closes the dialog.

Cancel

Does not retain any changes and closes this dialog.

Displays the help document about this feature.

Ignores the setting and closes this dialog.