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.