Anaplan XL Reporting has several options to define your own calculations.
Grid calculation on columns and rows
Used only in grid-based reports, grid calculations enable you to define your own dynamic calculations within a grid report.
They enable Excel formulas to be used within the grid, based either on visible data or on other elements on the worksheet.
For more information, see Grid calculations.
MDX calculated members
MDX calculations are a simple but powerful means to manage calculated members, sets, and custom MDX commands that live in the session and are executed on connection.
They're more involved to implement than grid calculations, but enable more complex and flexible calculations.
For more information, see MDX calculations.
Anaplan XL OLAP formulas
Anaplan XL has several formulas that enable you to bring cube data into Excel. This allows you to create complex workbooks interacting in all the complex ways that Excel allows.
For more information, see Formula reporting overview and an Anaplan XL formula reference.
MDX: and MDXSet: members
Grids and formulas can both refer to an MDX: calculation defined in an Excel cell. In addition, grids can use MDXSet: in an Excel cell to define a named set. Information can be found here:
