OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 237

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 434
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 236
Figure 236: 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 237, the location is now C7.
Figure 237: 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)
Chapter 8 Using the DataPilot 237
Vista de pagina 236
1 2 ... 232 233 234 235 236 237 238 239 240 241 242 ... 433 434

Comentarios a estos manuales

Sin comentarios