Forum Discussion
Pivot Table Values not matching Source values (Max Date)
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.
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.
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?
If Pivot Table add data to data model creating Pivot Table:
If rounding source data, you may add one more column with formula
=MROUND([@A],"00:00:01")That's a column C in this sample
and pivot your data based on this column.
Thank you so much, SergeiBaklan.
dwanajw , you are welcome