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.
JKPieterse
Sep 19, 2019Silver Contributor
Can you post a workbook with just the ID's and dates and a pivot based on those two?