BookmarkSubscribe
Choose Language Hide Translation Bar
learnJMP
Community Member

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

  

0 Kudos
1 REPLY 1
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
0 Kudos