SOLVED
Summarize / Consolidate Duplicate Values
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Isabroks
5 - Atom
‎01-03-2025
09:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello team,
I'm trying to consolidate or summarize duplicate values, but not sure how to get this.
This is my original dataset:
Employee | Store | District | Count |
1 | A | a | 35 |
2 | A | a | 30 |
3 | A | a | 22 |
1 | B | b | 20 |
1 | C | c | 21 |
2 | B | b | 21 |
2 | B | b | 18 |
3 | B | b | 15 |
2 | C | c | 12 |
3 | C | c | 10 |
I want to output the following:
Employee | Store | District | Count |
1 | A | a | 76 |
2 | A | a | 81 |
3 | A | a | 47 |
Solved! Go to Solution.
2 REPLIES 2
binuacs
21 - Polaris
‎01-03-2025
09:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Isabroks The following settings in the summarize tool should work
‎01-03-2025
10:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It worked!! Thanks :D
