The Select Fields dialog helps you to select the fields according to whose unique values to calculate DistinctSum. It appears when you do one of the following:
- Select DistinctSum from the Aggregate Function drop-down list and then select next to the Distinct On text box in the New Summary dialog, Edit Summary dialog, Insert Summary dialog, New View Element dialog, Edit View Element dialog, New Aggregation dialog, Edit Aggregation dialog, Insert Aggregation dialog or Aggregate On dialog.
- In the Display screen of the Create Crosstab wizard or Crosstab Wizard, select DistinctSum from the Aggregate text box and then select in the Distinct On text box.
- In the Summary screen of Create Table wizard, Table Wizard, Create Banded Object wizard or Banded Wizard based on query resources, Horizontal Banded Wizard, Mailing Label Wizard or Shape Map Data Binding Wizard, select DistinctSum from the Aggregate Function text box and then select in the Distinct On text box.
- Right-click one or more aggregations in a crosstab and on the shortcut menu point to Switch Aggregate Function, then select DistinctSum from the submenu.
The following are details about options in the dialog:
Lists all the available data resources.
Adds the selected fields from the Resources box to the Distinct On box.
Removes the selected fields from the Distinct On box.
Lists the fields according to whose unique values to calculate DistinctSum.
Applies the selected fields and closes the dialog.
Cancels the selection and exits the dialog.
Displays the help document about this feature.