Excel is fantastic at doing calculations, and Microsoft has added two types of calculations to pivot tables. You can add a new item along an existing dimension, or you can add a completely new field altogether. In the next chapter, you will learn how to fully utilize calculated fields and calculated items. |