It’s World Statistics Day! To honor the theme of the day, the JMP User Community is having conversations about the importance of trust in statistics and data. And we want to hear from you! Tell us the steps you take to ensure that your data is trustworthy.
Choose Language Hide Translation Bar
Highlighted
learnJMP
Level I

Total count per column from multiple entries reference by group

Hi, 

I've been searching all over and I still can't find an answer.  I would like to know if anyone would know a script that help with the total # of count of record for each different column reference by group?  Below is an example table

 

I would like to know what is the total # of count of site, fail 1, fail 2 base on WW column and group by Program.  A new table will output like the 2nd table below.  

 

Greatly appreciate of all the help that I can get. 

 

Programwwsitefail 1fail 2
a1123  
a123411
a1534  
a1243 1
a2543  
a2567 1
b25131 
b33214 1
b34351 
b33451 
b435  
b43 1
c4651 
c53651 
c54531 
c5412 1
c523411

 

ProgramWWTotal # of siteTotal # of fail 1Total # of fail 2
a1412
a12 1

  

1 REPLY 1
Highlighted
txnelson
Super User

Re: Total count per column from multiple entries reference by group

If your Site, Fail 1, Fail 2 etc. columns are numeric, then

     Tables==>Summary

will create the output table you want

Jim
Article Labels

    There are no labels assigned to this post.