Exchange rates Report: Default Grouping

Grouping by Rows

By default, the Exchange rates report groups data by date and currency.

The default grouping by date and currency is defined in the rows section of the basic Exchange rates report. To set it up, the field has been added by which data in the report has to be grouped by rows. However, you can change the pre-defined settings and choose how to group data by yourself.

To do that:

1. On the page for configuring report parameters, click the Customize button.
2. In the rows section, view and customize the default grouping as follows:
• To add fields for grouping, click the Select an option box, and then select a field by which you want to group data from the list of options.

The list displays fields from the selected report type which you can use to group data by rows.

• To remove fields, click the cross icon next to the field you wish to remove.

You can use the following fields from the selected report type to group report data by rows:

Grouping by Columns

In the basic Exchange rates report, default grouping is not set up. However, you can define your own groupings, if necessary.

To do that, you use the columns section of the report, where you can choose how to group data by yourself as in case of the groupings by rows. You do that as follows:

1. On the page for configuring report parameters, click the Customize button.
2. Use the columns section to view and customize the default groupings.

As with groupings by rows, in the columns section, you add fields by which you want to group data. The set of fields available for grouping data by columns is the same as for grouping data by rows.

Note
The report makes use of user-defined currency exchange rates set up with the Currency exchange rate directory.

More information