I've been an Excel user for 20 years. Pivot tables aren't my specialty but I use them quite often. I've run into an issue where my pivot table totals (grouped by week) were not matching the totals coming from my ERP system. When I drilled down on the pivot table total, I noticed the data detail doesn't match the master data extracted out of the ERP system into the table supplying the pivot table.
I'm running Office 2013 - 64 bit.
By chance is this a "known" issue under certain circumstances?
I have 14 data records. 13 records match (spreadsheet matches pivot table detail). 1 record doesn't match. Record at issue is below. The last field (-10.78) is included in the pivot table sum. The detail lists it as -5.61. (There is no data in the master data with a value of -5.61.) My pivot table sum is off by the difference.
Data from spreadsheet
000 3/11/2017 BC Itm Est 0000015761 N * 02 00317031 7009908 16501 -10.78
Data from pivot table detail
000 3/11/2017 BC Itm Est 0000015875 N * 02 00317031 7009923 3555 -5.61
Any ideas on how to address this? It's happening with numerous data records. This is just one example.
My first thought - sorting the data into weekly buckets by using a grouping is somehow causing the issue.
Bookmarks