Function GETPIVOTDATA
From Apache OpenOffice Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
- Introduction
- Examples with Step-by-Step Descriptions
- Functions in Detail
- The Database
- Start
- Data Sources
- The Pivot Table Dialog
- 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
Function GETPIVOTDATA
The function GETPIVOTDATA can be used with formulas in Calc if you need to reuse results from a Pivot Table elsewhere in your spreadsheet.
| Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |
