# Making a Change/Variation Column using previous row data

Hi all.
Change(variation): I am trying to make in glide tables the variation between Row1 and Row 2 and so forth. In GS it is simple but manual task, now that i am trying to use GlideTables its much more challenging.
Maybe there is a video or topic done on this already that even though ive looked have not found? if not, what would be the simplest way to proceed to do this?
I will add an example of my table in GS:

Thank you all!

The below should be helpful. It’s not exactly the same, but you should be able to use a similar approach.

3 Likes

Thank Darren. Though i can manage to replicate your exact example, i cant get around to getting the value between difference between week 1 and w2.

So circling back to your original post, do you mean you need to see the “change” column, and that change is calculated only based on the “Total 1+2” column?

At the end, do you want that “Total 1+2” column to be a computed column as well, opposed to what you have as a number column now?

You can have a math column to calculate the previous week, a relation/query to relate to the previous week from the current row, lookup the previous week’s total, and finally a math column to get the “change” value. Apply formatting as needed afterwards.

1 Like
1. is calculated only based on the “Total 1+2” column: yes
2. “Total 1+2” column to be a computed column as well: yes
3. math column to calculate the previous week, a relation/query to relate to the previous week from the current row, lookup the previous week’s total, and finally a math column to get the “change” value: seems as this could work. i will try to do this. thank you. (PS if u have any additional material on the relation/query part would be greatly appreciated).
1 Like