S
Slim Slender
Game Count Team Errors Type
1 1 Home None n/a
1 Visitor None n/a
2 1 Home Error A
2 Visitor None n/a
3 1 Home None n/a
3 Visitor Error B
4 1 Home Error C
4 Home Error D
4 Visitor None n/a
5 1 Home Error A
5 Home Error B
5 Home Error C
5 Visitor Error A
6 1 Home None n/a
6 Visitor Error A
6 Visitor Error B
Here is some dummy sample data. The "Count" field contains a formula:
=if(countif(a$2:a2,a2)>1,"",1) which gives a count of unique games in
a PivotTable. I can also very easily get a count of Total Errors with
a PT. What I can't figure out is how to get a count of Games with
Errors which I know is 5 (Games 2 thru 6). Any solution is welcomed:
one or more new fields in the data table, a calculated field in a PT,
a sumproduct or any other formula, whatever works.
1 1 Home None n/a
1 Visitor None n/a
2 1 Home Error A
2 Visitor None n/a
3 1 Home None n/a
3 Visitor Error B
4 1 Home Error C
4 Home Error D
4 Visitor None n/a
5 1 Home Error A
5 Home Error B
5 Home Error C
5 Visitor Error A
6 1 Home None n/a
6 Visitor Error A
6 Visitor Error B
Here is some dummy sample data. The "Count" field contains a formula:
=if(countif(a$2:a2,a2)>1,"",1) which gives a count of unique games in
a PivotTable. I can also very easily get a count of Total Errors with
a PT. What I can't figure out is how to get a count of Games with
Errors which I know is 5 (Games 2 thru 6). Any solution is welcomed:
one or more new fields in the data table, a calculated field in a PT,
a sumproduct or any other formula, whatever works.