Hello,
I have 2 rows and 42 columns of data not including the header row, and I need to create a third row with the variance between the first two rows. I want to subtract row record number 20 from row record number 25 for each column starting with the total column. How can I do this in Alteryx? I've tried Multi-field, Multi-row, and generate row tools, but I can't seem to get it right. I feel like I am on the right path, but I need a little help building out the tools. Attached is my scrubbed data set.
Thank you in advance!
