Total count per column from multiple entries reference by groupHi,
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.
| Program | ww | site | fail 1 | fail 2 |
| a | 1 | 123 | | |
| a | 1 | 234 | 1 | 1 |
| a | 1 | 534 | | |
| a | 1 | 243 | | 1 |
| a | 2 | 543 | | |
| a | 2 | 567 | | 1 |
| b | 2 | 513 | 1 | |
| b | 3 | 3214 | | 1 |
| b | 3 | 435 | 1 | |
| b | 3 | 345 | 1 | |
| b | 4 | 35 | | |
| b | 4 | 3 | | 1 |
| c | 4 | 65 | 1 | |
| c | 5 | 365 | 1 | |
| c | 5 | 453 | 1 | |
| c | 5 | 412 | | 1 |
| c | 5 | 234 | 1 | 1 |
| Program | WW | Total # of site | Total # of fail 1 | Total # of fail 2 |
| a | 1 | 4 | 1 | 2 |
| a | 1 | 2 | | 1 |
Re: Total count per column from multiple entries reference by groupIf your Site, Fail 1, Fail 2 etc. columns are numeric, then
Tables==>Summary
will create the output table you want
