Count of model

[santu1021]

Dear,

I have a hugh data of models sold with serial number and I'm looking to know how many sold with similar number

As-Is		Requried
Model	Serial Number		Model	Count of Serial Number (Sold)
M1	1234		M1	23
M1	1235		M2	6
M1	1236		M3	3
M1	1237
M1	1238
M1	1239
M1	1240
M1	1241
M1	1242
M1	1243
M1	1244
M1	1245
M1	1246
M1	1247
M1	1248
M1	1249
M1	1250
M1	1251
M1	1252
M1	1253
M1	1254
M1	1255
M1	1256
M2	123
M2	123
M2	123
M2	123
M2	123
M2	123
M3	123456
M3	123456
M3	123456

[vivran22]

Hi @santu1021 

As per the sample dataset shared and the output required, you could get it by simply using any visual or a table visual:

Just select the option of count after selecting the Model field twice:

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

[santu1021 · Accepted solution]

Thank You !!!