Excel 2016 Pivot Table Data Crunching (includes Content Update Program) (MrExcel Library) by Bill Jelen & Michael Alexander

Author:Bill Jelen & Michael Alexander [Jelen, Bill]
Language: eng
Format: azw3
Publisher: Pearson Education
Published: 2015-11-05T05:00:00+00:00

* * *

* * *

Caution

If the parent hierarchy or parent member is changed in the OLAP cube, your calculated member ceases to function. You must re-create the calculated member.

* * *

Managing OLAP Calculations

Excel provides an interface for managing the calculated measures and calculated members in an OLAP pivot table. Simply place your cursor anywhere in the pivot table and select the PivotTable Tools Analyze tab. Then select Manage Calculations, as shown in Figure 9.28.

Figure 9.28 Activate the Manage Calculations dialog.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.