Forum Discussion
Pivot Table Values not matching Source values (Max Date)
- 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.
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.
- dwanajwSep 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?
- SergeiBaklanSep 26, 2019Diamond Contributor
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.
- dwanajwSep 26, 2019Copper Contributor
Thank you so much, SergeiBaklan.
- JKPieterseSep 20, 2019Silver ContributorHi Sergey, I didn't know that.
Funny enough, if you change the format of the source data to general and then create a normal pivottable it does get the correct precision.- SergeiBaklanSep 20, 2019Diamond Contributor
Hi Jan Karel,
It also rounds in formula bar
That's only formatting, but if hit enter in formula bar milliseconds will be rounded. Perhaps same story with some other operations, don't know.
- JKPieterseSep 23, 2019Silver ContributorYes I know about that indeed, thanks.