Calculate the total number of sales data within various columns

Hello,

I'm new to Alteryx and require help for what is (probably) a basic / straightforward task.

I have 12 months worth of sales data from January to December in columns, illustrated below. I want to calculate the total sales across the 12 months into a new column called, 'Total Sales'.

Thanks,

Help

Accepted answers

BrandonB

Transpose then summarize! The transpose will take all of the columns and turn them into rows and then it will be easy to sum the values using a summarize tool directly after.

All comments

BrandonB

Transpose then summarize! The transpose will take all of the columns and turn them into rows and then it will be easy to sum the values using a summarize tool directly after.

arundaka02

Thanks @BrandonB,

I've used the Transpose tool and then Summarize to group the city with 'Group by' and the column with all sales values to 'Sum' which has calculated the sum of all monthly sales data against each city.

Solved.

amazz24

Hi @arundaka02

EDIT - please ignore as it appears that you solved the issue as I was typing my response.

Original response:

If I am reading this correctly, you will need to use the formula tool and name it "Total Sales". The formula will be:

[Jaunuary]+[February]+[March]+[April]+[May]+[June]+[July]+[August]+[September]+[October]+[November]+[December]

This will add a column to the right of your dataset and add up all of the preceding columns.

If this is the correct solution, please mark it as such.

Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703