Previous Page Next Page
This dialog appears when you click 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.
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.
OK
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.