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