Introduction

Apache OpenOffice 4.1 Calc Guide

Chapter 8: Using Pivot Tables

< Previous Section

Next Section >

• Introduction
• Examples with Step-by-Step Descriptions
  • Example 1: Sales Volume Overview
    • Practical Problems and Questions
    • Solution
    • Advantages
  • Example 2: Timekeeping
    • Practical Problems and Questions
    • Solution
    • Differences and Advantages
  • Example 3: Frequency Distribution
    • Solution with an Array Formula
    • Solution with a Pivot Table
• Functions in Detail
  • The Database
  • Start
  • Data Sources
    • Calc Spreadsheet
    • Registered Data Source
  • The Pivot Table Dialog
    • Basic Layout
    • More Options
    • More Settings for the Fields – Field Options
    • Data Fields
    • Row and Column Fields
    • Page Fields
  • Working with the Results of the Pivot Table
    • Start the Dialog
    • Change Layout by Using Drag and Drop
    • Grouping Rows or Columns
    • Grouping of Categories with Scalar Values
    • Grouping of Categories with Date or Time Values
    • Grouping without the Automatic Creation of Intervals
    • Sorting the Result
    • Drilling (Showing Details)
    • Filtering
    • Updating or Refreshing Changed Values
    • Cell Formatting
  • Multiple Data Fields
  • Shortcuts
• Function GETPIVOTDATA
  • Difficulty
  • Syntax
    • First Syntax Variation
    • Second Syntax Variation

< Previous Page

Next Page >

Introduction

Many requests for software support result from complicated formulas and solutions that try to solve simple day-to-day problems. Another solution is to use a Pivot Table, a tool for easily combining, comparing, and analyzing large amounts of data. With a Pivot Table, you can summarize the same source data in a variety of ways, displaying the details of areas of interest and creating reports.

This chapter is divided into two sections:

• “Examples with Step-by-Step Descriptions” uses three typical cases to demonstrate the advantages and applications of a Pivot Table. Follow the examples to learn how easy it is to use this tool.
• “Functions in Detail”, describes the use of Pivot Tables in detail. You can use this part to look up how a function is used, and it is not necessary to understand or even read through all of this section to use Pivot Tables effectively.