Share
Report
116I've inherited a big Sharepoint list of live data. It's rows of people then columns if training and other stuff its 350 columns wide by 5000 rows... I'm over faced by the numbers 😯
All the columns
| Name | Training 1: date | Training 1: Status | Training 2: date | Training 2: Status | Training 3: date | Training 3: Status | Training 4: date | Training 4: Status |
| Bob | etc.. | Overdue | etc.. | Overdue | Overdue | Complete | ||
| Anne | Overdue | Overdue | Overdue | Overdue | ||||
| Claire | Overdue | Complete | Due | Overdue | ||||
| Simon | Overdue | Overdue | Due | Complete | ||||
| Sarah | Complete | Overdue | Due | Overdue | ||||
| pat | Complete | Due | Complete | Overdue | ||||
| Chris | Complete | Complete | Complete | Complete |
I want to see the data in 2 ways
1. What's due in a number summary
| Training | Due | Overdue | Total |
| Training 1 | 0 | 4 | 4 |
| Training 2 | 1 | 4 | 5 |
| Training 3 | 3 | 2 | 5 |
| Training 4 | 0 | 4 | 4 |
2. Needs training:
| Training 1 |
| Bob |
| Anne |
| Claire |
| Simon |
Categories:
All responses (
Answers (
