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'