You have to understand the terminology associated with pivot tables. It is the first step to the master Excel pivot table. See the following Figure.
Column labels
Each item in the field occupies a column. In our above figure, Customer represents a column field and Customer contains two items (Existing and New). There may have nested column fields.
Read More:Â How to Insert a Calculated Item into an Excel Pivot Table!
Grand totals
A row or column that displays totals for all cells in a row or column in a pivot table. Grand totals can be calculated for rows, columns, or both (or neither). The pivot table shown in the above figure shows the grand totals for both rows and columns.
Group
A group is a collection of items treated as a single item. The pivot table shown in our figure does not have any defined groups.
Item
Item is a field that appears as a row or column header in a pivot table. In our above figure, Existing and New are items for the Customer field. The Branch field has three items: Central, North County, and Westside. AcctType has four items: CD, Checking, IRA, and Savings.
Refresh
Refresh recalculates the pivot table after you have made some changes to the source data.
Row labels
Each item in the field occupies a row. Nested row fields are also possible. In the above figure, Branch and AcctType both represent row fields.
Source data
Source data is the data that is used to create a pivot table. Source data can in a worksheet or an external database.
Subtotals
The pivot table shown in the figure displays subtotals for each branch, below the data. You can also display subtotals above the data or hide subtotals.
Table Filter
Using a table filter, you can choose one item, multiple items, or all items in a page field at one time. In the figure, OpenedBy represents a table filter that displays All items. Click on it, and you can choose different options to choose from.
Read More:Â How to Create an Average Calculated Field in Excel Pivot Table
Values area
Values areas are the cells in a pivot table that contain the summary data. Excel offers many ways to summarize the data (sum, average, count, and so on).
Right-click on any value in the pivot table and then use the following figure to change the option.
Download Sample File
Happy Excelling 🙂
Really, The website from which you interpreting things about excel is excellent !!
Thanks Buddy for your contribution on this.
Shivaji,
It is my achievement when a person says me that I helped him/her in some way. Thanks. Keep in touch.
Could you please send me the resources for Excel VBA and ACCESS VBA Including books
Shivaji,
Right now I have no book on Microsoft Access. But just subscribe my Email list using the below link, you will get two books on Excel: 1200+ Macro Examples E-Book, 220+ Excel Keyboard Shortcuts E-Book and other Excel resources.
http://www.eepurl.com/bqFItv