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.
The values in your pivot table are all 0. It seems that a regular pivot table cannot deal with that small numbers.
Try a data model pivot table instead. It works for me.
Thanks Detlef_Lewin​ for your response, could you please share the steps along with the attached worksheet .
Thanks & Regards
Anupam
Go to Insert > PivotTable. In the "Create PivotTable" dialog box, select your table range and be sure to check the box that says "Add this data to the Data Model" before clicking OK.
(Copied from a chatbot answer)