Summarize data

[skeen503979]

Hello team, 

Can someone please advise me on how to use the Summarize tool to achieve the following?  Currently, I have a list of data down to the Serial # level.  Each row contains multiple attributes I want to summarize.  How can I summarize the data per attribute and only show the total number of serial numbers that meet that attribute?  (Total number of Blue items? Total number of Small items, etc.)

[MarqueeCrew · Accepted solution]

Quick Reply:

 count distinct serial #
 group by attribute 1

Group by attribute 2

 group by attribute 3

cheers,

 mark

[skeen503979]

Thanks @MarqueeCrew for the quick reply!  That produces what I need.

[Qiu]

@skeen503979 

As an illustration of @MarqueeCrew solution