Example dataset:
Is it possible to show "Yes" for 1 and "No" for 0 while still retaining aggregate functionality? Basically, the aggregate should be a sum which is a count of "Yes".
Company | Material | Collected |
A | Stone | 1 |
A | Wood | 0 |
A | Marble | 1 |
A | Plastic | 1 |
B | Stone | 0 |
B | Wood | 0 |
B | Marble | 0 |
B | Plastic | 1 |
C | Stone | 1 |
C | Wood | 1 |
C | Marble | 1 |
C | Plastic | 1 |
Is it possible to show "Yes" for 1 and "No" for 0 while still retaining aggregate functionality? Basically, the aggregate should be a sum which is a count of "Yes".