Forum Discussion
Solved
Summary Table with Sub set
I’m trying to create a summary table like the one below. It compares zones and across the business by staff rating excluding staff that are currently being trained, which is a yes no flag
| Business Area | Rating | business Zone A | business Zone B | business Zone C |
| Area A | all staff | 12 | 10 | 9 |
| 0-2 | 0 | 1 | 0 | |
| Area B | all staff | 13 | 15 | 16 |
| 0-2 | 2 | 3 | 0 | |
| Area C | all staff | 15 | 18 | 18 |
| 0-2 | 1 | 6 | 0 | |
| Company | Total staff | 40 | 43 | 43 |
| 0-2 | 3 | 10 | 0 |
