Home

Pivot Table

STRACTROOP
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

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies