Microsoft Office Tutorials and References
In Depth Information
Analyzing data dynamically by using PivotTables
If the PivotTable Fields pane isn’t visible, you can display it by clicking any cell in the
PivotTable, which displays the PivotTable Tools tabs. On the Options tool tab, in the Show/
Hide group, click Field List.
To assign a field, or column of data, to an area of the PivotTable, drag the field header from
the Choose Fields To Add To Report area at the top of the PivotTable Fields pane to the
Drag Fields Between Areas Below area at the bottom of the pane. For example, if you drag
the Volume field header to the Values area, the PivotTable displays the total of all entries in
the Volume column.
Search JabSto ::

Custom Search