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 22.214.171.124 (ubuntu)
Versión: 126.96.36.199 (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
Sounds good -> NEW