Calc Guide

Function GETPIVOTDATA
The function GETPIVOTDATA can be used with formulas in Calc if you
want to reuse the results from the DataPilot elsewhere in your
spreadsheet.
Difficulty
Normally you create a reference to a value by entering the address of
the cell that contains the value. For example, the formula =C6*2
creates a reference to cell C6 and returns the doubled value.
If this cell is located in the results area of the DataPilot, it contains the
result that was calculated by referencing specific categories of the row
and column fields. In Figure 219, the cell C6 contains the sum of the
sales values of the employee Hans in the category Sailing. The formula
in the cell C12 uses this value.
Figure 219: Formula reference to a cell of the DataPilot
If the underlying data or the layout of the DataPilot changes, then you
must take into account that the sales value for Hans might appear in a
different cell. Your formula still references the cell C6 and therefore
uses a wrong value. The correct value is in a different location. For
example, in Figure 220, the location is now C7.
Chapter 8 Using the DataPilot 267