Forum Discussion

dwanajw's avatar
dwanajw
Copper Contributor
Sep 18, 2019
Solved

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...
  • SergeiBaklan's avatar
    Sep 19, 2019

    dwanajw 

    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.

Resources