Calc Guide

If you enter only the first two arguments, then the function returns the
total result of the DataPilot.
You can add more arguments as pairs with field name and element to
retrieve specific partial sums. In the example in Figure 221, where we
want to get the partial sum of Hans for sailing, the formula in cell C12
would look like this:
=GETPIVOTDATA("sales value";A1;"employee";"Hans";"category";"sailing")
Figure 221: First syntax variation
Second syntax variation
The argument DataPilot has to be given in the same way as for the
other syntax variation.
For the specifications, enter a list separated by spaces to specify the
value you want from the DataPilot. This list must contain the name of
the data field, if there is more than one data field, otherwise it is not
required. To select a specific partial result, add more entries in the
form of Field name[element].
In the example in Figure 222, where we want to get the partial sum of
Hans for Sailing, the formula in cell C12 would look like this:
=GETPIVOTDATA(A1;"sales value employee[Hans] category[sailing]")
Chapter 8 Using the DataPilot 269