How would I insert a row which is the variance between two other rows?

lhongo · 2022-08-15T20:28:55+00:00

There was an error rendering this rich post.

Find more posts tagged with

It’d be easier to pivot your data in an ETL and then use a formula tile or beast mode to calculate the difference between the two column values.

@GrantSmith , I tried doing that but it was just not as straightforward as I expected,what should I have in

Step 3 : Name a new column to create

Step 4: What label identifies the rows that belong to this column

Step 5: Select what values will populate this new column