Microsoft Excel 2016 Data Analysis and Business Modeling (opal opal parris' Library) by Wayne L. Winston

Author:Wayne L. Winston
Language: eng
Format: epub
Publisher: Microsoft Press
Published: 2016-09-27T04:00:00+00:00

FIGURE 43-41 Creating a calculated field.

FIGURE 43-42 The PivotTable with a calculated field for variance percentage.

Thus, in January, sales were 4.7 percent lower than budgeted. By displaying the Insert Calculated Field dialog box again, you can modify or delete a calculated field.

How do I use a report filter or slicer?

To see the sales of Chip 2 in France, for example, you can drag the Product and Country fields to the Filters area. With Chip 2 and France selected, you would see the PivotTable shown in Figure 43-43. Figure 43-44 shows how to create the same table with slicers (see the Slicers worksheet).

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.