+ Reply to Thread
Results 1 to 5 of 5

Pivot Table Drill Down

  1. #1
    Registered User
    Join Date
    05-22-2015
    Location
    United States
    MS-Off Ver
    2010
    Posts
    3

    Pivot Table Drill Down

    I am having trouble drilling down on a Pivot Table. I have two tables linked together and am using slicers to filter the fields. The field I am drilling down on is a "count" of customers that purchased a specific item from my Company. The slicer that drives the pivot charts and pivot tables is resulting in a correct count in both the chart and pivot table. However, when I go to the pivot table to drill down on the resulting count, it gives me more data than the resulting count in the pivot chart and pivot table.

    For example, once I use the slicers, I am getting 34 customers that meet the filtered criteria. The 34 count is shown in the pivot chart and pivot table total. If I double click the pivot table total of 34 to drill down excel returns more customers than the 34 I'd like to view. Any idea on how to fix this?

    I hope I articulated this clearly. Any help or guidance would be greatly appreciated.

  2. #2
    Forum Contributor
    Join Date
    08-11-2004
    Posts
    109

    Re: Pivot Table Drill Down

    Are the customer's duplicated when you drill in?

  3. #3
    Registered User
    Join Date
    05-22-2015
    Location
    United States
    MS-Off Ver
    2010
    Posts
    3

    Re: Pivot Table Drill Down

    Nope. They are not duplicated.

  4. #4
    Registered User
    Join Date
    05-22-2015
    Location
    United States
    MS-Off Ver
    2010
    Posts
    3

    Re: Pivot Table Drill Down

    It looks like unfiltered data. If I drill down on the pivot table and enter the filters to correspond with the slicers, the table returns the 34 customers.

  5. #5
    Forum Contributor
    Join Date
    08-11-2004
    Posts
    109

    Re: Pivot Table Drill Down

    Sorry need the spreadsheet to figure this one out.

+ 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 lhughes1983 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-18-2014, 04:44 PM
  2. Pivot table- drill down
    By Bala Daniel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2014, 03:58 PM
  3. Drill Down Updates from a Pivot Table linked to a table
    By BON1985 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2012, 10:18 AM
  4. Pivot Table drill down
    By andyperiam in forum Excel General
    Replies: 1
    Last Post: 09-18-2009, 01:11 AM
  5. 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