Using the DataPilot

OpenOffice.org 3 Calc Guide

Chapter 8 Using the DataPilot

< Previous Section

Next Section >

• Example: Sales volume overview
• Example: Timekeeping
• Example: Frequency distribution
• DataPilot functions
• Data source
• DataPilot dialog
• Working with the results of the DataPilot
• Sorting, drilling, filtering, refreshing
• Multiple data fields
• GETPIVOTDATA

< Previous Page

Next Page >

This is Chapter 6 of the OpenOffice.org 3 Calc Guide, produced by the OOoAuthors group.

Introduction

In requests for office software support there are regularly questions caused by some awkward solution strategies for day to day exercises in a spreadsheet. By not knowing simple but powerful concepts, users create very complicated formulas. A much more solid, simple, and flexible solution is based on using the DataPilot.

The DataPilot is not just a tool for advanced users. If beginners would know about this tool, it would save them many hours of work.

This chapter is divided into two sections:

• Examples with step by step descriptions uses three typical cases to demonstrate the advantages and applications of the DataPilot. You can follow these examples and learn by doing how easy it is to use the DataPilot.
• DataPilot functions in detail describes the DataPilot in detail. You can use this part for looking up how a function is used.

Examples with step by step descriptions

This section demonstrates some of the possibilities of the DataPilot in some typical use cases. By following the step by step description, you should be able to recreate the examples yourself and learn about the power of the DataPilot.