I have a data set where I am trying to parse out the times used and total mileage for each vehicle. I can get the pivot table to give me the sum of the mileage difference (COLUMN E) and a COUNT of times used, but not the SUM of times used. Right now with the data below I have correct data as long as the times used lists each day separately. If it's combined (i.e. times used 12) the pivot table returns a 1.
Pivot Table:
Row LabelsCount of TimesUsed2Sum of Mileage Diff.Count of TimesUsed
| G10-1271M | 0 | 545 | 1 |
| G12-0304P | 0 | 230 | 9 |
| G41-0527V | 0 | 420 | 14 |
| G41-1738S | 0 | 128 | 1 |
Data:
| Tag Number | TimesUsed | Mileage Begin | Mileage End | Mileage Diff. |
| G10-1271M | 1 | 15111 | 15656 | 545 |
| G12-0304P | 1 | 8417 | 8522 | 105 |
| G12-0304P | 1 | 8396 | 8417 | 21 |
| G12-0304P | 1 | 8394 | 8396 | 2 |
| G12-0304P | 1 | 8393 | 8394 | 1 |
| G12-0304P | 1 | 8377 | 8393 | 16 |
| G12-0304P | 1 | 8345 | 8377 | 32 |
| G12-0304P | 1 | 8311 | 8345 | 34 |
| G12-0304P | 1 | 8306 | 8311 | 5 |
| G12-0304P | 1 | 8292 | 8306 | 14 |
| G41-0527V | 1 | 44545 | 44547 | 2 |
| G41-0527V | 1 | 44509 | 44545 | 36 |
| G41-0527V | 1 | 44506 | 44509 | 3 |
| G41-0527V | 1 | 44493 | 44506 | 13 |
| G41-0527V | 1 | 44490 | 44493 | 3 |
| G41-0527V | 1 | 44481 | 44490 | 9 |
| G41-0527V | 1 | 44424 | 44481 | 57 |
| G41-0527V | 1 | 44369 | 44424 | 55 |
| G41-0527V | 1 | 44361 | 44369 | 8 |
| G41-0527V | 1 | 44235 | 44361 | 126 |
| G41-0527V | 1 | 44219 | 44235 | 16 |
| G41-0527V | 1 | 44183 | 44219 | 36 |
| G41-0527V | 1 | 44151 | 44183 | 32 |
| G41-0527V | 1 | 44127 | 44151 | 24 |
| G41-1738S | 12 | 8883 | 9011 | 128 |
How do I get a SUM of times used?
