Division of two rows; get diff in %

[LuneLune]

Hello,

I want to compare the prices of all my toys with dragons. Dragon is the first row while two toys are below. They are in yellow below.

The result should be a separate column (marked in blue), price difference shown in percentage.

Basically, I want to see how cheaper other toys are because the dragons are the most expensive in my store.

Can you please help how this in Alteryx as it is plain easy in Excel?

Thanks

[clmc9601]

Hi @LuneLune,

Here is a workflow that calculates the percent difference. I hope it helps!

[Tyro_abc · Accepted solution]

Hi @LuneLune 

This is my workflow, I took the first row separately and then joined with the original file.  So, first row can be anything and you can still compare with first row toy.

[pedrodrfaria]

Hi @LuneLune 

Please see attached the workflow below:

For educational purpose, I created two different workflows to accomplish this task. One that is based on which product you want to compare using the name. And the second one is based on the order of the list.

Please assign the solution(s) to the discussion post. This helps us all.

Pedro.

[LuneLune]

Thank you all for help, it works perfectly.