Adding Calculated Rows and Columns in a Table
You can add a calculated member to any dimension in a table by inserting a blank row or column next to an existing dimension member, and typing a formula.
Context
While you can still create calculated members based on the Account or Cross Calculations dimensions using the Calculation Editor, creating calculated rows and columns can provide more flexibility. For example, you don't really need to create a restricted measure to calculate the variance between an Actual and a Budget version.
Repeating: uses one dimension member and the calculation appears wherever that dimension member appears.
Single: uses multiple dimensions in the calculation and appears only once.
Procedure
Example:
To calculate the difference between a Budget and Actuals version, you can add a calculated column based on the Version dimension:-
Right-click the column header of the Budget version and select
Add column.
- To name the new column, select the header, type Variance, and press Enter.
- Select the Variance cell again and type the formula. Use the cell coordinates of the Budget and Actuals column headers, or select each column to create references. For example, =C2-B2. Press Enter.

The new column shows the difference between the Budget and Actual version for each account. You can also perform this calculation using restricted measures based on the Cross Calculations dimension.