Contents
Copyright..............................................................................................................................2
Contributors................................................................................................................................. 2
To this edition..........................................................................................................................2
To previous editions................................................................................................................2
Feedback..................................................................................................................................... 2
Publication date and software version.........................................................................................2
Using LibreOffice on macOS........................................................................................................2
Introduction..........................................................................................................................5
Database preconditions............................................................................................................... 5
Data sources................................................................................................................................ 6
Calc spreadsheet....................................................................................................................6
Registered data source...........................................................................................................6
Using shortcuts............................................................................................................................6
Creating a pivot table................................................................................................................... 6
The Pivot Table Layout dialog............................................................................................7
Basic layout.................................................................................................................................8
More options................................................................................................................................ 9
More settings for the fields: Field options...................................................................................11
Options for data fields...........................................................................................................12
Options for row and column fields.........................................................................................14
Options for page fields..........................................................................................................18
Working with the results of the pivot table.....................................................................18
Changing the layout................................................................................................................... 18
Grouping rows or columns......................................................................................................... 19
Grouping of categories with scalar values.............................................................................19
Grouping of categories with date / time values......................................................................20
Grouping without automatic creation of intervals...................................................................21
Sorting the result........................................................................................................................ 23
Select sort order from drop-down menus on each column heading.......................................24
Sort manually by using drag and drop...................................................................................24
Sort automatically..................................................................................................................25
Drilling (showing details)............................................................................................................ 25
Filtering...................................................................................................................................... 26
Updating (refreshing) changed values.......................................................................................28
Cell formatting............................................................................................................................ 28
Deleting a pivot table................................................................................................................. 29
Using pivot table results elsewhere.................................................................................29
The problem............................................................................................................................... 29
The solution: Function GETPIVOTDATA().................................................................................30
Syntax................................................................................................................................... 30
First syntax variation.............................................................................................................30
Second syntax variation........................................................................................................30
Using pivot charts..............................................................................................................31
Introduction................................................................................................................................ 31
Creating a pivot chart.................................................................................................................33
Chapter 8 Pivot Tables | 3