+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Drill Down Doesn't Match Master Data

  1. #1
    Registered User
    Join Date
    02-20-2017
    Location
    Missouri
    MS-Off Ver
    2013 64-Bit
    Posts
    2

    Pivot Table Drill Down Doesn't Match Master Data

    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.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Pivot Table Drill Down Doesn't Match Master Data

    Hi,

    I've never heard of that actually happening. I've seen one or two reports but they turned out to be issues with the workbook setup (connecting to the wrong thing) rather than pivot tables inventing data. Is it possible to share the table and pivot table in question?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table Drill Down
    By Colin12 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-27-2015, 09:09 AM
  2. Pivot Table Drill Down
    By lhughes1983 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-18-2014, 04:44 PM
  3. Pivot table- drill down
    By Bala Daniel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2014, 03:58 PM
  4. Pivot Table Total doesn't match data total
    By CNL.Excel in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-31-2013, 07:40 PM
  5. Formula to copy pivot table results if match into master sheet
    By monmar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-16-2012, 10:03 PM
  6. Pivot Table drill down
    By andyperiam in forum Excel General
    Replies: 1
    Last Post: 09-18-2009, 01:11 AM
  7. Pivot table drill-down via VB
    By dsuprina in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2007, 12:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1