Forum Discussion
dwanajw
Sep 18, 2019Copper Contributor
Pivot Table Values not matching Source values (Max Date)
My pivot table is changing the value of the source data to a different number, even though the cells are formatted exactly the same. I have a table containing dates of calls with timestamps for i...
- Sep 19, 2019
Yes, it works like this
Actually your timestamp has seconds and milliseconds. If add data to data model creating Pivot Table you have correct result. If not - Pivot Table rounds milliseconds.
SergeiBaklan
Sep 19, 2019Diamond Contributor
Yes, it works like this
Actually your timestamp has seconds and milliseconds. If add data to data model creating Pivot Table you have correct result. If not - Pivot Table rounds milliseconds.
dwanajw
Sep 26, 2019Copper Contributor
Thank you for explaining why it's happening. So How can I add the millisecond value to the Pivot table calculations? OR remove the millisecond value from the source data before creating the pivot table?