Adding global calculated rows or columns
Use the command Add Calculated Row / Column to add a calculated row or column to a table.
You can also add a calculated row or column using the mouse right button.
To add a calculated row or column:
- In the Explore menu choose Add calculated Row / Column. The Row / Column dialogue box appears.
- Add a row or column pressing the corresponding button.
- Choose Global from the box On Dimension
- In the Select function section, you should choose the function you wish to add. It may be a user-defined function or a standard one.
- Click OK. The table is updated.
To add a calculated row or column using the right button of the mouse:
- Right-click the background of the table. A shortcut menu is displayed
- Add a row or column:
- If you are adding a row, choose Add Calculated Row
- If you are adding a column, choose Add Calculated Column
- Add a function:
- To add a standard function, select Standard Functions with the mouse..
- To add a user-defined function, select User-Defined Functions.
- Choose a function. The table is updated.
Adding a calculated row or column to a Dimension
Use the command Add Calculated Row / Column to add a calculated row or column to a dimension.
You can also add a calculated row or column, using the right button of the mouse over the name of the dimension in the table or graph.
To add a calculated row or column:
- Choose Add Calculated Row / Column in the Explore menu. The dialogue box, Add Calculated Row / Column appears.
- Add a row or column pressing the corresponding button.
- Choose a dimension from the list On Dimension
- In the Select Function section, you must choose the function you need to add. It may be a user-defined function or a standard one.
- Click OK . The table is updated.
To add a calculated row or column using the right button of the mouse:
- Right click on the dimension label. A shortcut menu appears.
- Add a row or column
- Choose a function. The table is updated.
- To add a standard function, select Standard Functions.
- To add a user-defined function, select User-defined functions
Picture 1: Adding calculated elements
Calculated rows or columns are added to each element of the dimension and are calculated every time from the elements in the embedded dimension.
Calculated rows and columns remain associated to one dimension until they are explicitly removed from the table.
Calculated rows and columns are visible in the charts but can only be removed from the spreadsheets. You can also remove a calculated row or column from one dimension.