Forum Discussion
Solved
Time-Axis doubt
Dear Experts, I have a data as attached and below, I want to have the Time-diff in Y-Axis, but seems none is plotted:- Could you please share what wrong I am doing here. T...
Yes, we can't sum datetime. We could find, for example, min or max for it. Use source as numbers, sum and apply datetime format to resulting field.
In addition. Cached PivotTable round milliseconds (as well as formula bar,
)
One workaround is to work with data model as Detlef explained. Another way is to apply to Time-diff column General format, create cached PivotTable and apply to the result custom number format with milliseconds. (or created copy of TimeDiff column in the table formatted as General and build PivotTable using it).
See also Pivot Table Values not matching Source values (Max Date) | Microsoft Community Hub