Create a pivot table Write in a cell a reference to pivot table The content of the cell writed must change to auto-generated function =GETPIVOTDATA(...) with the result in cell referenced in the pivot table.
Same that this behaviour in Excel: https://exceltotal.com/referencias-a-tablas-dinamicas/
It is need this funcionality really. Confirmed in version 6.3.4.2 (ubuntu)
Confirmed in: Versión: 6.4.1.2 (x64) Id. de compilación: 4d224e95b98b138af42a64d84056446d09082932 Subprocs. CPU: 2; SO: Windows 6.1 Service Pack 1 Build 7601; Repres. IU: predet.; VCL: win; Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc: threaded
Sounds good -> NEW
*** This bug has been marked as a duplicate of bug 145966 ***