OFFSET function in a table view
I'm looking to create a table that will dynamically show change between the row and the row above it. We need the table to automatically update the formula when one of the rows is filtered out (which makes doing this in ETL impossible). My idea was to do this with an LAG function or an OFFSET function, but since we're working in beast mode I don't belive LAG is an option. I appreciate any advice you all have and have provided a quick example of how I would like the table to behave!