Overriding column calculations

You can override the values coming from the data model, row calculations, or custom column calculations by right-clicking a column header and choosing “Replace column formula”.

The calculation will apply to all columns coming from the same field in the Value Field setting.

To override column values coming from the data model, follow these steps:

1. Ensure you are in edit mode.
2. Right-click the column (header) you want to override the calculation/value for.
3. Create the formula for the calculation. Column formulas support functions to perform calculations. To use functions, type the function name, then provide the arguments to the function. To reference value in the data grid, place the caret in the formula editor and click a cell value to insert a reference.

Step 1

Step 2

Step 3