Examples with Step-by-Step Descriptions

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 >

Examples with Step-by-Step Descriptions

This section demonstrates some of the possibilities of Pivot Tables. By following the step-by-step description, you can recreate the examples and learn about the power of this tool.

In several places in the following examples, there is an instruction to "select a cell." It can be very important that only a single cell be selected.