Home

Pivot Table

Occasional Visitor

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-1271M05451
G12-0304P02309
G41-0527V042014
G41-1738S0128

1

Data:

Tag NumberTimesUsedMileage BeginMileage EndMileage Diff.
G10-1271M11511115656545
G12-0304P184178522105
G12-0304P18396841721
G12-0304P1839483962
G12-0304P1839383941
G12-0304P18377839316
G12-0304P18345837732
G12-0304P18311834534
G12-0304P1830683115
G12-0304P18292830614
G41-0527V144545445472
G41-0527V1445094454536
G41-0527V144506445093
G41-0527V1444934450613
G41-0527V144490444933
G41-0527V144481444909
G41-0527V1444244448157
G41-0527V1443694442455
G41-0527V144361443698
G41-0527V14423544361126
G41-0527V1442194423516
G41-0527V1441834421936
G41-0527V1441514418332
G41-0527V1441274415124
G41-1738S1288839011128

How do I get a SUM of times used?

1 Reply
Highlighted

Perhaps your TimesUsed column is in text format. For numbers you shall be able to sum it.

Related Conversations
Counting Days
Tim Hunter in SQL Server on
2 Replies
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Problem sorting Pivot Table according to date
MikkoS in Excel on
1 Replies