Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Field Settings The PivotTable can use these functions with your data: Sum Average Max Min Product Count Numbers StvDev StDevp Var and Varp   If you would like, you can show the values as a percent of the row, column, group or total. You can also display the values as the difference, % of difference or running total.

PivotTable ->Options ->Field Settings