A
PivotTable can use these functions: Sum Average Max Min Product Count
Numbers StvDev StDevp Var and
Varp
4. Try This: Choose the Calculation
Select Sum from the options.
The Custom Name should update to Sum of
Amount.
Click OK and keep going...
Memo to Self: You can
summarize 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 if you wish.
PivotTable Tools ->Options-> Active Field->
Field Settings
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.3. Apply and manipulate PivotTables:
Field Settings |
|
| |
