Calculate the total number of sales data within various columns
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
KA
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nice work and thanks for asking your question in Community! We are happy to help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
![](/skins/images/59DA3CA97FC6306BFE8B6DED203F3AC0/responsive_peak/images/icon_anonymous_message.png)