Calculated fields pivot table in Excel
http://www.xlninja.com/2012/07/16/cal...
When you set a pivot table up in Excel you might want to perform calculations using the base data.
For instance, you might have information about sales revenue and sales commission and you might want to calculate the commission percentage in order to understand how much your sales people are earning in commission.
You can easily do so within a pivot table.