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. ItemmonthClassificationValueCategoryNameChairJan - 2022Furniture50000 Home FurnitureProfitChairJan - 2022 Furniture50Home FurnitureSalesChairJan - 2022 Furniture1000 = 50000/50Home FurnitureRevenue

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

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

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?

Please find the solution below.

Hi Shanker,

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

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.

Revenue_DZ.yxmd

I have tried for a huge data set also.

It worked.

Please find the result below.

Many thanks

Shanker V

Input:

Output:

Many thanks

Shanker V

@kiotsuresh

Please let me know if you are looking for the similar result.

Step 1: Input the data

Step 2: Sort, as you might have clumsy data.

Step3: Using RecordID to have unique values in each row

Step 4:

Step 5:

Step 6:

Step 7: Union tool

Step 8: Sorting to have formatted output

Kindly accept this solution if it provided a solution to your question.

Shanker V

Please check and let me know if my solution works.

Many thanks

Shanker V