Multiplying 1 row of data by 1 column of data

Hello,

I am trying to multiply a column by a row of percentages in order to get a value for each state. What is the best way to do this? See attached file. The total column is the data that I want to multiply by the ratios in the row at the bottom. I want to populate an amount for each row for each state.

Alteryx Question 03.12.2024.xlsx

Best Practices

Transformation

Preparation

Accepted answers

cjaneczko

This is one way to do it.

Multiplying 1 row of data by 1 column of data.yxmd

All comments

cjaneczko

Is this what your input looks like or is this your desired output? There are a few ways to go about this. An iterative or batch macro seems like one of the ways you would want to tackle it. Its going to require cleansing the table a bit first though if this is what the dataset starts out like.

ebledsoe22

Hi @cjaneczko, I would say both. This is how the dataset starts, but I want to populate each column with the product of the total column and the ratios at the bottom. For example, If you look at column AL000000, I want each row of AL to show the product of the values in the Total column multiplied by the ratio at the bottom of the AL000000 column.

cjaneczko

This is one way to do it.

Multiplying 1 row of data by 1 column of data.yxmd

SPetrie

Another option would be using dynamic replace to add in formulas for the columns.

dynamic replace example.yxmd

ebledsoe22

Thank you for your response. This worked perfectly.

ebledsoe22

Thank you to everyone for your speedy suggestions.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703