jonespandrew
New member
- Joined
- Jan 27, 2016
- Messages
- 122
- Reaction score
- 0
- Points
- 0
Hi there this is my pivot table However I am trying to create a Percentage colum at then end wich works out the pass rate Grand total /pass how can i do this.
Region | (All) | |||||
Lot | (All) | |||||
Amey? | (All) | |||||
Complete By | (All) | |||||
Count of Test/Pass/IP/Overdue/Fail | Column Labels | |||||
Row Labels | FAILED | IN PROGRESS | OVERDUE | PASSED | (blank) | Grand Total |
FOSTON HAL | 6 | 21 | 268 | 295 | ||
GARTREE | 4 | 48 | 409 | 461 | ||
GLEN PARVA | 13 | 1 | 47 | 256 | 317 | |
LEICESTER | 1 | 69 | 240 | 310 | ||
LINCOLN | 5 | 47 | 435 | 487 | ||
MORTON HAL | 5 | 8 | 55 | 266 | 334 | |
N SEA CAMP | 11 | 225 | 236 | |||
NEWBOLD | 29 | 92 | 121 | |||
NOTTINGHAM | 1 | 74 | 546 | 621 | ||
ONLEY | 18 | 5 | 32 | 636 | 691 | |
RANBY | 1 | 88 | 561 | 650 | ||
STOCKEN | 74 | 425 | 499 | |||
SUDBURY | 6 | 35 | 296 | 337 | ||
WHATTON | 4 | 32 | 483 | 519 | ||
(blank) | ||||||
Grand Total | 53 | 25 | 662 | 5138 | 5878 |