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 |
I have To Perform this operation for a larger Datasets to achieve a new row dimension ( Revenue).
Hi @kiotsuresh
You can achieve the diving of values with the help of multi row formula.
Many thanks
Shanker V
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?
Hi @kiotsuresh
I have tried for a huge data set also.
It worked.
Please find the result below.
Many thanks
Shanker V