Chapter 30: Analyzing Data with PivotTables
3030
FIGURE 30.35
Formatting applied to the data model PivotTableWhen you create a PivotChart using the data model, you can convert the PivotTable to formulas. Select any cell
in the PivotTable, and choose PivotTable Tools Analyze ➪ Calculations ➪ OLAP Tools ➪ Convert to Formulas. The
PivotTable is replaced by cells that use formulas. These formulas use CUBEMEMBER and CUBEVALUE functions.
Although the range is no longer a PivotTable, the formulas update when the data changes.