[Libreoffice-ux-advise] [Bug 145966] [PIVOTTABLE] Add =GETPIVOTDATA(...) formula when referencing data inside a pivot table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=145966

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |libreoffice-ux-advise at 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 <heiko.tietze at documentfoundation.org> ---
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 on the CC list for the bug.