Skip to main content

Select Fields

  • Updated

BackPrevious TopicNext TopicNext

Select Fields

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 or Function drop-down list and then select the button Select Resource next to the Distinct On text box in the Add Aggregation dialog, Insert Aggregation dialog or Aggregate On dialog.
  • In the Data tab of the Crosstab Wizard, Insert Crosstab dialog or Convert to Crosstab dialog, or in the To Crosstab dialog, select DistinctSum from the Aggregate drop-down list and then select the button Select Resource next to the Distinct On text box.
  • Right-click an aggregation that is based on a detail object in a crosstab and on the shortcut menu point to Switch Function, then select DistinctSum from the submenu.

Select Fields dialog

Resources

Lists the group and detail objects in the current business view. For a crosstab, only the detail objects are listed.

Add Item button

Adds the selected fields from the Resources box to the Distinct On box.

Remove Item button

Removes the selected fields from the Distinct On box.

Distinct On

Lists the fields according to whose unique values to calculate DistinctSum.

OK

Applies the selected fields and closes the dialog.

Cancel

Cancels the selection and exits the dialog.

Help button

Displays the help document about this feature.

Close button

Ignores the setting and closes this dialog.

BackPrevious TopicNext TopicNext