group same numbers into one number

Question

&nbsp;Hello, I need help with this file. I need to group all of the part numbers together so that it only reads one part number but then have a column that reads how many times that PN came up.&nbsp;Like this&nbsp;PN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Count000-110-006&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3003-001-006&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100861-0556-0001&nbsp; &nbsp; &nbsp; 9&nbsp;&nbsp;Many thanks!

phil_seamark · Accepted Answer

Hi&nbsp;baBI123&nbsp;If you drag your Part Number field to the values area of your table visual twice, you can set the properties of one of the fields to be a count of...&nbsp;

Forum Discussion

group same numbers into one number

2 Replies

Related content

Sum of Number in group

number format help

Tooltip numbers

Number Format Issue

Creating groups based on numbers