So use OLAP PivotTable Extensions in Excel 2013 for some of the other features it offers, which are detailed below. It even includes a drag and drop field and function list. Thankfully, in Excel 2013 Microsoft does provide a UI for building MDX calculations for the first time. They appear in the Field List pane at the very top under the Values grouping:įor help with advanced calculation properties for these private PivotTable calculations, or for help with MDX expressions, refer to our Calculations Help page. Those calculations appear in the PivotTable just like any other calculations: OLAP PivotTable Extensions let you define your own calculated measures which are private to that particular PivotTable: Adding extra Excel calculations in the cells surrounding the PivotTable has some limitations as they are not part of the PivotTable and can be wiped out if the dimensions of the PivotTable change, and plain Excel calculations must only operate on data visible in the PivotTable. But there is no built-in UI to define your own MDX calculations.
This page is currently under construction as we migrate off our old Codeplex page is still on Codeplex.Īny calculated members which are part of the Analysis Service cube on the server can be added to PivotTables. The add-in can be launched from the following menu option in the right-click menu for PivotTables: It also adds some new features like searching cubes, configuring default settings, and filtering to a list in your clipboard. OLAP PivotTable Extensions provides an interface for some of this functionality. The Excel API has certain PivotTable functionality which is not exposed in the UI. OLAP PivotTable Extensions is an Excel add-in which extends the functionality of PivotTables on Analysis Services cubes.