Forum Discussion

santu1021's avatar
santu1021
Icon for Helper II rankHelper II
6 years ago
Solved

Count of model

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
ModelSerial Number ModelCount of Serial Number (Sold)
M11234 M123
M11235 M26
M11236 M33
M11237   
M11238   
M11239   
M11240   
M11241   
M11242   
M11243   
M11244   
M11245   
M11246   
M11247   
M11248   
M11249   
M11250   
M11251   
M11252   
M11253   
M11254   
M11255   
M11256   
M2123   
M2123   
M2123   
M2123   
M2123   
M2123   
M3123456   
M3123456   
M3123456   
Need Help

2 Replies

  • vivran22's avatar
    vivran22
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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