Ask Your Question

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

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

migueldealmeida gravatar image

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

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 +0100

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 +0100

Seen: 156 times

Last updated: Jan 26 '19