Create a new row by multiply one row with a number

[esun1028]

Greeting everyone,

I have a data set that looks like below

District	2021	2022	2023	2024
Site A	24	23	25	26
Site B	50	48	49	51
Site C	65	20	19	21
Total	2160	2113	2116	2122

I am trying to create a new last row with data that multiply the "Total" row with the same coefficient of 0.94.

Any suggestion of how to do it? Thanks in advance.

[DavidP · Accepted solution]

Hi @esun1028 

Something like this perhaps?

[esun1028]

hi @DavidP

It works perfectly. Thanks a lot!

One more question, if I need to create a new row with the data that I need to type in, how could it be achieved in Alteryx?

Thanks again for your help!