Attempting to sum Multiple Columns that meet a certain criteria (dynamic)
- 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
Prod # | Description | CG | Totals | 5 SHP | 5 MMS | 5 Other | 12 SHP | 12 MMS | 12 Other | 14 SHP | 14 MMS | 14 Other |
1 | Apple | 48 | 291 | 15 | 65 | 84 | 48 | 79 | ||||
2 | Orange | 48 | 841 | 54 | 651 | 4 | 84 | 48 | ||||
3 | Pear | 48 | 213 | 5 | 51 | 51 | 8 | 98 | ||||
4 | Banana | 48 | 597 | 45 | 51 | 8 | 484 | 9 | ||||
5 | Pineapple | 48 | 137 | 45 | 8 | 84 | ||||||
6 | Grapes | 48 | 101 | 1 | 4 | 48 | 48 |
I need help trying to combine columns that start with the same number (store number) into a single column.
For example. What is the sum of Orange for Store 5 (5 SHP + 5 MMS + 5 Other) ?
Please note:
This has to be dynamic in the sense that I don't know what other stores will be added or taken away but the format will not change.
So if a store 16 shows up i know it will come in 3 columns and be laid out like (16 SHP, 16 MMS, 16 Other). I am just looking for a way to combine each column that is split into 3 columns currently so that the output is 1 single column with the sum of all 3 columns.
Please help me! I am very new to Alteryx.
Solved! Go to Solution.
- Labels:
- Datasets
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for taking the time to reply! This is where I was stuck as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad to help and thank you for the accept mark!
