Browsing Analysis Services OLAP Cubes with Excel - Microsoft Business Intelligence Tools for Excel Analysts - page 259

Figure 13-15: Add your newly created calculation to your PivotTable via the PivotTable Fields list.

Your calculated measure adds a meaningful layer of analysis to the PivotTable (see Figure 13-16).

Figure 13-16: Your PivotTable now contains your calculated measure.

When you create a calculated measure, it exists in your workbook only. You're not building
your calculation directly in the OLAP cube on the server. This means no one else connected
to the OLAP cube can see your calculations unless you share or distribute your workbook.

Note