mTarget

Use mTarget to perform calculations using the target for a measure that you select. If you select a multivalue target from the Report Target list on the toolbar, mTarget uses the value of the first subtarget in the order you defined reating the multivalue target. For example, for this multivalue target, the Maximum subtarget is used as it is first in the order.

Figure 17. Sample Multivalue Target Subtarget Order

The file multivaluetargetorder displays how you can order subtargets.

See Creating Multivalue Targets

  To use mTarget:

  1. Select Application Data, then Measures, and double-click mTarget.

  2. Select the measure to use from the Select Measure box. To use the current measure, select This Measure.

    For example, this formula insets the current target for the Total Sales measure:

    mTarget(“TotalSales”)

    To use this function with other functions to perform calculations using previous targets, entertimeOffset(mTarget(“measure name”), -interval)).