Three "Work-Arounds" for Calculated Fields in Excel Pivot Tables
A Calculated Field is a "virtual field" in an Excel Pivot Table.You create a new field as a result of a formula that uses existing data fields - or other calculated fields.
There are times, however, when a calculated field does not give you the result(s) that you expected. This is because a Calculated Field always performs it calculations against the SUM of your data!
In this tutorial, I demonstrate three "work-arounds" for calculated fields that allow you to get the results you know are possible. This means that you will use your Pivot Table as a "means to an end." Let your Pivot Table get you 95% of the way to your result and then work on a copy of the values that the Pivot Table produced.
Danny Rocks
The Company Rocks
Смотрите видео Three "Work-Arounds" for Calculated Fields in Excel Pivot Tables онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Danny Rocks 28 Июль 2011, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 175,147 раз и оно понравилось 471 людям.