Changing Pivot Table Calculations.
1. From the Sum of
Amount drop down arrow select
the option Value Field Settings.
The Value list Setting dialog
box is displayed.
2. Select the required function.
3.
Ok button.
The calculations on the Pivot Table will
update automatically.
In this example we changed the function from Sum to Average.
No comments:
Post a Comment