Calc Guide

Figure 220: The value that you really want to use can
be found now in a different location.
The function GETPIVOTDATA allows you to have a reference to a value
inside the DataPilot by using the specific identifying categories for this
value.
Syntax
The syntax has two variations:
GETPIVOTDATA(target field, DataPilot; [ Field name / Element; ... ])
GETPIVOTDATA(DataPilot; specification)
First syntax variation
The target field to specify which data field of the DataPilot is used
within the function. If your DataPilot has only one data field, this entry
is ignored, but you must enter it anyway.
If your DataPilot has more than one data field, then you have to enter
the field name from the underlying data source (for example “sales
value”) or the field name of the data field itself (for example “sum –
sales value”).
The argument DataPilot specifies the DataPilot that you want to use.
It is possible that your document contains more than one DataPilot.
Enter here a cell reference that is inside the results area of your
DataPilot. It might be a good idea to always use the upper left corner
cell of your DataPilot, so you can be sure that the cell will always be
within your DataPilot even if the layout changes.
Example: GETPIVOTDATA("sales value";A1)
268 OpenOffice.org 3.x Calc Guide