Move Calculations

You can drag calculations to any location on an axis in PowerPlay Web reports, using the enhanced UI. You can also position the calculation at the top or on the left of the crosstab. When calculations are moved, they remain fixed in the position that you specify as long as you continue exploring within the same dimension in the crosstab. You can move calculations in a time dimension, unlike time categories that cannot move.

If you move a calculation under a category that is not a parent of the calculation’s operands, the operand values are set to zero. For example, if you move the calculation Camping Equipment +1 under a category that is not a parent of Camping Equipment, the calculation produces the value one for all rows. This is because the value of Camping Equipment is set to zero. The operand is also set to zero when you set the dimension bar filter to a category that is not a direct ancestor of the operands of the calculation.

The following restrictions apply when dragging calculations in a crosstab:

• Calculations must be specified as moveable.
• Calculations can be moved only within the same dimension.
• Forecast calculations and ranks cannot be moved.

By default, calculations are not moveable unless a setting is enabled when the calculation is created.

Steps

1. In the PowerPlay Web display, right-click the calculation row heading or the calculation column heading, and then click Edit Calculation.
2. In the Calculations dialog box, click Moveable and click OK.
3. Click the calculation and drag it to the new location in the report. A drop zone indicator bar indicates where the calculation can be dropped.

If the crosstab changes, the movable calculation moves relative to the category to which it is related. It remains next to this category as long as the category is visible in the crosstab and the hierarchy of the dimension remains the same. Unlike a non-movable calculation, the calculation does not change locations when the definition of the calculation changes.