The Using drop-down menu contains aggregate statistical functions that are available when you sort by values. The functions generally duplicate the data functions available in the active section.
The default function for sorting is Sum. When you sort by values, Interactive Reporting sorts dimensional data by the corresponding numeric values of the referenced item (for example, sorting states by the sum total of the cost of goods sold in each state).
To specify a sort using the features of the Sort line:
If the Sort line is not already displayed, click Sort on the Section title bar.
Select a value from the By drop-down list as a sort reference, or select Label to sort the item alphabetically.
If desired, select an aggregate function from the Using drop-down list when sorting by values.
The Using drop-down menu is not available when you sort by labels.
If desired, click Sort on the Sort line.
The Sort line stores a sort condition for each dimensional item included in the report.