Part V: Understanding Power Pivot and Power Query
FIGURE 37.22
These cells are now a series of Cube functions!
If your PivotTable contains a report filter field, the dialog box shown in Figure 37.23 acti-
vates. This dialog box gives you the option of converting your filter drop-down selectors
to Cube formulas. If you select this option, the drop-down selectors are removed, leaving a
static formula.
FIGURE 37.23
Excel gives you the option of converting your report filter fields.
If you need to have your filter drop-down selectors intact so that you can continue to
change the selections in the filter field interactively, be sure to leave the Convert Report
Filters option unchecked when clicking the Convert button.
Now that the values you see are no longer part of a PivotTable object, you can insert rows
and columns, you can add your own calculations, or you can combine the data with other
formulas in your spreadsheet. Cube functions give you the flexibility to free your Power
Pivot data from the confines of a PivotTable and use it in all sorts of ways by simply moving
formulas around.
