Once a calculation has been added to an object, it will appear at the top of the 'Smart calculations' pad.
If an added calculation is clicked, the following properties may be changed:
§ Calculation title: Change the title of this calculation.
§ Range: Define the range, e.g. from first column to last column, to which this calculation must apply.
§ Source: Define the referenced column/row for the calculation, either ‘current’ or another relatively referenced column/row.
§ Source (Measure): Change the measure for the calculation.
§ Move Calculation to the other axis: A calculated column will become a calculated row, and vice-versa.
§ Swap X and Y references: If the formula has a defined range, e.g. calculation of average of all measures from first column to last column of last row, you can swap X and Y references to calculate the average of all measures from first row to last row of last column instead. This property is only available for calculations that are added as a new measure.
Continuing the ‘Total’ example from the Add a Calculation topic, the default title for the bottom row of the cross-tab object names ‘Total’ can be changed to ‘Calc-Total’ by clicking on the calculation in the list you wish to change (e.g., ‘Total’), as shown below.