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.
@Isabroks The following settings in the summarize tool should work
It worked!! Thanks :D