We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Is there a way to refer to a Pivot Table's total cell?

asked 2019-01-26 20:19:09 +0200

migueldealmeida gravatar image

updated 2020-08-30 23:33:36 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-01-26 21:57:26 +0200

Regina gravatar image

Yes, use the function GETPIVOTDATA. See help, or from older OOo guide, or in German, or section 'Using Pivot Table results elsewhere' in the Calc user guide chapter 8.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-26 20:19:09 +0200

Seen: 192 times

Last updated: Jan 26 '19