Calculate the difference between 2 records and generate output in record 3

[rohin92]

Hi,

I want to calculate the difference between the two rows for the first 4 columns with numbers and generate the output in a 3 row. I have attached how my view looks.

I will always have 2 records only to calculate the difference between.

[cjaneczko]

Summarize tool followed by a Union back to the original data set. You may need to create an index to identify the paired rows as a means to group the summaries. 

[Yoshiro_Fujimori]

Hi @rohin92 ,

I followed your requirement using Transpose & Cross Tab twice. (Please check the configuration of each tool.)

The order of the rows depends on the string in the [Comment] column.

I hope this helps.

Workflow