Create New Data Row by dividing two values from the existing rows.?

[kiotsuresh]

Hi,

I have Data like below where i need to populate the third row by dividing the values of row 1 and row 2 , Revenue = Profit/Sales, How to achieve this through Alteryx. I need to Populate the Value as well as new name Revenue from the existing data set. 

Item	month	Classification	Value	Category	Name
Chair	Jan - 2022	Furniture	50000	Home Furniture	Profit
Chair	Jan - 2022	Furniture	50	Home Furniture	Sales
Chair	Jan - 2022	Furniture	1000 = 50000/50	Home Furniture	Revenue

[kiotsuresh]

I have To Perform this operation for a larger Datasets to achieve a new row dimension ( Revenue).

[ShankerV]

Hi @kiotsuresh 

You can achieve the diving of values with the help of multi row formula.

Many thanks

Shanker V

[KrishnaChithrathil]

@kiotsuresh 

is this something you want?

[ShankerV]

Hi @kiotsuresh 

Please find the solution below.

[kiotsuresh]

Hi Shanker,

Will This works for the entire dataset where 10000 records or there? or just for three records?

[kiotsuresh]

Will This works for the entire dataset where 10000 records or there? or just for three records?

[DenisZ]

Please find attached solution. This should also work for multiple items. 

[ShankerV]

Hi @kiotsuresh 

I have tried for a huge data set also.

It worked.

Please find the result below.

Many thanks

Shanker V

[ShankerV]

Hi @kiotsuresh 

Input:

Output:

Many thanks

Shanker V