I have a pivot table with a bunch of columns indicating the value over time, and would like to create a calculated field showing the change over each value. How would I reference the previous (and next) column's value in the calculated field in the pivot table?

bumped to the homepage by Community yesterday

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.


According to Google Sheets documentation, available here, you can use the names of the previous and next fields to customize your calculated field formula.

You can use other columns to write a formula. For example, you can use =sum(Price)/counta(Product) where "Price" and "Product" are fields in the pivot table.

protected by Community Oct 16 '18 at 21:17

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.