Unioning Multiple Summarize Tools to Get Group and Total

Question

Hi everyone, I could use some help ASAP! I think this should be an easy solution I just can't seem to find it. I am using a summarize tool to group by grocery store item categories, then count how many distinct items are in that category. However I also want to get a total count of distinct items across all item categories. Can this be done in one summarize tool? I have it set up in two, one to get my total and the other to get the totals for each separate group, and then I unioned them, but I want them all on the same line. Anyone have a solution?

AMansour · Accepted Answer

Hi @carimoffitt

I don't think that you can do both in the same summarize. I'll go for Distinct Item by Category then the total distinct. then you can use Append Fields to append the total to each row then you can calculate the percentage.

Hope that helps you

cheers

Amr