Help Topics

Calculation Editor


You can use the Calculation Editor to create and edit named calculated members that are displayed on the grid and chart. You can create a calculated member on either axis and move a calculated member from one axis to another.

Tip: The calculated members that you add are shown only in the view (in the grid or chart). The calculated members are not saved when you exit the application or close the browser. To preserve your calculations, bookmark the view by selecting Bookmarks > Add Bookmark from the menu bar. The calculated members are saved as part of bookmarks, but you must write custom Java code to restore a bookmark that contained only calculated members.

The initial panel of the Calculation Editor shows the list of available calculations in the left pane. The calculations are performed in the order that they are listed. If you highlight a calculation, the definition string for the calculated member appears in the right pane. You can copy the definition string to the clipboard by clicking the Copy to clipboard button.

Note: Copy to clipboard works only in Internet Explorer.

You can perform the following operations on a calculation:

Add
Creates a new calculation and adds it to the end of the list of available calculations.
Edit
Edits the selected calculation.
Delete
Deletes the selected calculation.
Duplicate
Creates a duplicate of the selected calculation and adds it to the end of the list of available calculations.
Move up
Moves the selected calculation up in the list.
Move down
Moves the selected calculation down in the list.

Related topics: