The PivotTable features in Excel allow you to perform a multitude of different calculations including SUM, AVERAGE, MIN, MAX and COUNT. In addition to these calculations you can also use the Show Value As options which extend a pivot table’s capabilities.
This video takes you through most of the Show Value As calculations available in Excel 2010. For example, you can calculate each row’s value as a percentage of the grand total row or if you are using subtotals each row’s value as a percentage of its parent row’s total. This video also shows you how to create a year-to-date running total which would be relevant to sales data, together with the ability to compare sales month on m0nth – you can show this as either difference or percentage difference.
Excel 2010 has extended the capabilities of the Show Value As options compared to legacy versions of the Excel – the design of the new Value Field Settings dialogue box has also made using these options easier to use.