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