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.
Row LabelsCount of TimesUsed2Sum of Mileage Diff.Count of TimesUsed