You can create custom calculations in Anaplan XL Reporting using the MDX formula wizard.

Access the wizard using the wand toolbar in the Custom calculations form. Alternatively, in the Measure member selector, right-click the measure or use the Calculated Value dropdown.

Calculation Types

Time

Various time calculations available include:

Time CalculationsOptions
Totals to Date
  • Year to Date (YTD)
  • Quarter to Date (QTD)
  • Month to Date (MTD)
Running totals
  • Average, Sum, and Total To date.
  • Running total in Report is only available in the context of a particular report, so must be accessed from the member selector.
Opening and closing valuesIncluding finding first/last non-blank values.
Comparisons to previous periodsActual and differences.

If the cube is configured with Year/Quarter/Month levels defined correctly, then Anaplan XL can find the correct levels for many of these calculations. If not, you will be asked to pick the appropriate level, for example, the year level for Previous Year calculations.

Slice

This shows the current measure, but for a different slice of the cube.

For example, you could specify that the new measure always shows the sales of Red products only rather than the full total.

Measure to base

This shows the current value as a percentage or the value at a higher level.

For example, by choosing Geography at the country level, you can see how much each state or city helps the country's overall value.

Rank position

This shows the rank of current row compared to the other values.

You can rank compared to

  • Axis: Ranked against the other rows in the grid.
  • Level: Ranked against other members at the same level.
  • Siblings: Ranked against other members with the same parent.

For example you can set sales ranking instead of the actual value. You can select both Value and Rank ‌for columns. 

DAX

If you are connected to a tabular data source, the DAX calculations tab is available.