How do I sum numbers by category. Instead of having two rows by the zip code of 35007, I would like just one but with the total being for both lines. Total Sales should equal $405.85 and Total Tax Collected should equal $16.23.
Solved! Go to Solution.
You can the Transform:Summarize tool. For State and Zip, select Group By. For the numeric fields, select Sum.
User | Count |
---|---|
106 | |
85 | |
76 | |
54 | |
40 |