https://bugs.documentfoundation.org/show_bug.cgi?id=145966
Heiko Tietze <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |libreoffice-ux-advise@lists | |.freedesktop.org URL| |https://help.libreoffice.or | |g/latest/en-US/text/scalc/0 | |1/04060109.html?DbPAR=CALC# | |bm_id7682424 --- Comment #2 from Heiko Tietze <[email protected]> --- Sounds okay to me to insert the GETPIVOTDATA() formula instead the actual value. But I wonder what type of formula to use, see online help. This example Cat 1 Sum - A 1 1,73490402254057 2 1,18748293692689 3 1,65489692181237 Total Result 4,57728388127982 shows per =GETPIVOTDATA(A1:B5;3) the value of B3. But I fail to do the same with B3 or in case of more than one result column. The formula GETPIVOTDATA(TargetField; pivot table[; Field 1; Item 1][; ... [Field 126; Item 126]]) is unclear to me, and the help not informative. So the question is a) does inserting a formula helps to understand how to use it, b) what benefit does this have (the result is the same as with =B3), and c) what type of formula to use. Me struggles with b) and somewhat a). -- You are receiving this mail because: You are the assignee for the bug.
