[Looker Studio] row-level arithmetic across different rows in the same column

[PhilChien]

Hello everyone, 

Does anyone know if it's possible to do the row-level arithmetic across different rows in the same column in looker studio?

Basically my original data look like the row 1st - 5th in the attached image and I want to create new data like the row 6th - 7th. The newly-created metric "average food value per order" will be the value of "food value" divided by the value of "orders".

Any feedback is much appreciated, thank you!

[a_aleinikov · Accepted solution]

Hi @PhilChien ,
Looker Studio can't do row-to-row math across rows. To solve this:

• Pivot data so "orders" and "food value" are in columns

• Then create a calculated field: food value / orders

[PhilChien]

Hi @a_aleinikov , 

I see, will try to use this alternative.

Thank you for the reply!