Table Calculation Becomes Invalid or Returns Unexpected Results After Adding to or Removing A Dimension From A View

Option 1 - Resolving an invalid table calculation.

1. Right-click the table calculation field in the view and select Edit Table Calculation.
2. In the Table Calculation dialog window, uncheck the red dimension in the list of Specific Dimension.

Note: Depending the table calculation, the dimension may be necessary to compute the table calculation correctly. In this case, the dimension cannot be removed from the view, but it's possible to modify the view to look like the dimension has been removed. For more information, please see Computing a Table Calculation by a Dimension Not Present in the View.

Option 2 - Resolving table calculation returning unexpected results

To resolve the table calculation returning unexpected results after adding an additional dimension to the view, there are two options:

• Add additional dimensions with an aggregation
  1. Add the dimension to the view.
  2. Right-click the dimension and select Measure > Minimum.
• Or, change which dimensions are used to address the table calculation.

Depending on how the view is built and exactly what values the table calculation should return, the correct Compute Using settings will vary. For more information on how the Compute Using settings change the output of a table calculation, please see Customize Table Calculations.