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:

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.

is calculated only based on the “Total 1+2” column: yes

“Total 1+2” column to be a computed column as well: yes

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).