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
Watch video Three "Work-Arounds" for Calculated Fields in Excel Pivot Tables online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 28 July 2011, don't forget to share it with your friends and acquaintances, it has been viewed on our site 175,147 once and liked it 471 people.