Pivot Tables
Purpose of a Pivot Table
-Used to summarize and analyze large volumes of data. -Two or three way tabular presentation of chosen fields. -Certain statistics can be calculated at the field intersections.
Adding and removing report totals fields to the value area
...
Classic Pivot Table Layout
...
Sorting within a Pivot Table
...
Adding a calculated field
Creating a field that doesn't exist in the database. -Use the field name.
Record
Group of related fields about one object or event. ROWS
Field
Represents and attribute or measurement of some object or event. COLUMNS
Filtering within a Pivot Table
TABS 3: All records including averages. 2: Just averages and grand averages. 1: Grand average total.
Database Hierarchy
-Data is made up of characters. -Related characters=field -Related fields=record -Related records=file -Related files=database CFRFD
Steps in creating a Pivot Table
-Familiarize yourself with the database. -Visualize what you want it to look like. -Place your active cell in the data and click on the Pivot Table icon in the Insert Ribbon. -Pivot Table Options/Display, click on Classic Pivot Table Layout. -Click and drag field names onto the page, row, column, or data areas.
Pivoting values from columns to rows
Drag
What goes on the top row?
Field Names
Purpose of refresh icon
Keeping the table's information correct with the database.
Database
Organized collection of related information.
Changing the Field Settings and Appearance
Pivot Table Tools -Options and Design Tabs