Guerilla Data Analysis Using Microsoft Excel by Oz du Soleil

Author:Oz du Soleil
Language: eng
Format: epub
Tags: Excel;data quality;data validation;sorting;matching lists of data;data consolidation;data subtotals;pivot tables;pivot charts;tables
Publisher: Holy Macro! Books
Published: 2015-11-07T05:00:00+00:00

In the next figure, you see that the new Sold+Lost field shows up as an available entry in the field list.

With Sold+Lost in the Values field, the total that’s “gone away” is estimated to be 19,337.22 ounces, as opposed to the 18,774 ounces previously estimated.

On your own, you could take this a step further and create a calculated field for loss.

NOTE

Calculated fields have limitations. First, they work only with numbers, not with text. In the example in this section, you might you know that the overall loss is 3%, but the loss on oils specifically is 6%; you can’t create a calculated field that calculates loss by individual types. For that kind of specificity, you’d do better to add a new column in the source data.

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.