I have a pivot table created in a Google Sheet that looks like this:

Desktop           | Mobile
Sessions | Trans. | Sessions | Trans. |
  250    |   34   |   150    |   25   |
 ....    |   ...  | ....     |   ...  |

It's basically some web stats grouped by Desktop vs Mobile. I'm trying to add a new column for each group that will calculate Trans. / Sessions

I tried adding a calculated field to the pivot table, but when I enter the formula it shows Formula parse error. The way I entered it is by adding the column name wrapped in single quotes:

='Trans.' / 'Sessions'

Here is an example.

  • Calculated fields work fine in my pivot table. Perhaps you could share yours so that the problem can be reproduced? – user79865 Aug 22 '15 at 23:18
  • Here's an example: docs.google.com/spreadsheets/d/… – Bogdan Aug 23 '15 at 14:27

It appears you were trying to enter 'SUM of Transations' and so on into the formula. But "SUM of" if not a part of the name, it's just an indication of how the column was summarized. The following works in the calculated formulas:


Since those columns are summarized using SUM, you will get the sum of transactions divided by the sum of sessions.

Quotes are not necessary here since you don't have spaces in column names.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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