Show TOC

To add a new measure based on one available measureLocate this document in the navigation structure

Procedure

  1. Select the measure heading that you want to use.
  2. Choose Start of the navigation path Calculations Next navigation step Add Dynamic Calculation Next navigation step [Operator] End of the navigation path.
    The following operators are available:
    Option Description
    Moving Minimum Value The new measure displays the smallest value available up to this point.

    For example, there are ten rows with values in your crosstab. The new measure starts in the first row with the same value as the original measure. If the second row in the original measure has a higher value than the first, the value of the first row is repeated in the second row of the new measure and so on.

    Moving Maximum Value The new measure displays the highest value available up to this point.
    Accumulative Sum The new measure displays the sum of all values up to this point.

    For example, the original measure has eight rows with values. In the fourth row of the new measure, the sum of first four rows is displayed.

    Accumulative Sum of Rounded Values The new measure displays the sum of all rounded values up to this point.
    Accumulative Count of All Detailed Values The values per measure are counted and numbered starting with 1 for the first value. If there are 8 rows with values, including zeros, that contribute to the total, the new measure displays the numbers 1 to 8 for the 8 values.
    Accumulative Count of All Detailed Values that are Not Zero, Null or Error The values per measure are counted and numbered starting with 1 for the first value, excluding values that are equal to zero.

    For values that are equal to zero, the last number is repeated.

    Moving Average The new measure calculates the average of all values up to this point.

    For example, if there are five rows with values in the crosstab, the new measure calulates in row 2 the average of the values in row one and two, and so on.

    Moving Average that is Not Zero, Null or Error The new measure calculates the average of all values up to this point, excluding values that are equal to zero.
    Rank Number The new measure displays a rank number for each value of the original measure. The highest value in the original measure has the rank number 1.

    If a value occurs more than once, the values are assigned to the same rank number. If there are two identical values with rank number 4, the next smallest value has rank number 5.

    Olympic Rank Number The Olympic ranked list differs from the basic ranked list as follows: In the Olympic ranked list, when a value occurs more than once, the next smallest value is not assigned the rank incremented by one, but the rank that corresponds to the number of previous values (including the current value).

    For example, if the rank 4 occurs twice, the new measure displays number 6 for the next smallest value rank.

    Percentage Contribution The new measure calculates the percentage contribution of a value in the original measure to the overall result of the original measure.

Results

The new measure is added to the crosstab and the design panel.