Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 26 Jan 2019 21:57:26 +0100Is there a way to refer to a Pivot Table's total cell?https://ask.libreoffice.org/en/question/180665/is-there-a-way-to-refer-to-a-pivot-tables-total-cell/When a pivot table is created, there is a "total" at the bottom of the table.
However, since the pivot table might be dynamic (i.e. number of rows can change if you change the underlying data), if you refer to that cell by it's absolute position (e.g. "'Sheet1.B33"), things might break if the pivot table changes the number of rows.
Is it possible to reference this cell in a way that does not break if the pivot table changes?Sat, 26 Jan 2019 20:19:09 +0100https://ask.libreoffice.org/en/question/180665/is-there-a-way-to-refer-to-a-pivot-tables-total-cell/Answer by Regina for <p>When a pivot table is created, there is a "total" at the bottom of the table.
However, since the pivot table might be dynamic (i.e. number of rows can change if you change the underlying data), if you refer to that cell by it's absolute position (e.g. "'Sheet1.B33"), things might break if the pivot table changes the number of rows.</p>
<p>Is it possible to reference this cell in a way that does not break if the pivot table changes?</p>
https://ask.libreoffice.org/en/question/180665/is-there-a-way-to-refer-to-a-pivot-tables-total-cell/?answer=180673#post-id-180673Yes, use the function GETPIVOTDATA. See [help](https://help.libreoffice.org/Calc/Spreadsheet_Functions#GETPIVOTDATA), or from older [OOo guide](https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/GETPIVOTDATA), or in [German](http://www.ooowiki.de/PivotdatenZuordnen.html), or section 'Using Pivot Table results elsewhere' in the Calc [user guide chapter 8](https://documentation.libreoffice.org/assets/Uploads/Documentation/en/CG4.1/PDF/CG4108-PivotTables.pdf). Sat, 26 Jan 2019 21:57:26 +0100https://ask.libreoffice.org/en/question/180665/is-there-a-way-to-refer-to-a-pivot-tables-total-cell/?answer=180673#post-id-180673