The following terms are used in PivotTable reports:
• Field: The header at the top of a column in a List (data source table).
• Item: Numeric data or text in the Field column.
• Data: An area detailing the data in the lower part of the PivotTable report, including columns with numeric data.
• Row Field: A field that is positioned as a row in the lower left of the PivotTable report.
• Column Field: A field that is positioned as a column in the row above the data in the PivotTable report.
• Page Field: A field that is positioned in the upper left of the PivotTable report.
Screenshot // PivotTable Report Terminology
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
At the same time, we thought that the terminology commonly used in the OLAP world was less than intuitive for businesspeople who simply want to retrieve the data they need to perform their jobs. Fortunately, the Excel PivotTable report feature has established a set of standard terminology with which many users are already familiar. We followed the terminology established by Excel, but changed just a few names where there was a better term to express the concept in the worlds of both tabular and multidimensional data.
Excel 97 included a new and improved PivotTable Wizard, the ability to create calculated fields, and new pivot cache objects that allow developers to write Visual Basic for Applications macros to create and modify pivot tables While tables such as these can contain many data items, it can be difficult to get summarized information from them. A pivot table can help quickly summarize the data and highlight the desired information. The usage of a pivot table is extremely broad and depends on the situation. The first question to ask is, "What am I seeking?" In the example here, let us ask, "How many