Microsoft Office Tutorials and References
In Depth Information
Working with PivotTable Data
Click the Analyze tab under PivotTable Tools.
To change the display values, select from the available options:
Summarize Values By. Right-click a field, point to Summarize Values By ,
and then select one of the summarize options (Sum, Count, Average, Max,
Min, or Product), or click More Options .
Show Values As. Right-click a field, point to Show Values As , and then se-
lect one of the show options, or click More Options .
To work with fields, items and sets, click the Fields, Items & Sets button, and
then select one of the options:
Calculated Field or Calculated Item
Solve Order
List Formulas
Create Set Based on Row Items
Create Set Based on Column Items
Manage Sets
Search JabSto ::




Custom Search