Excel Drill Down not working correctly - double click produces all data view

[smokeysnow]

Hello...I'm working in Excel 2007 and I'm using a data connection to SQL 2008. I've created a few pivot tables using the same datasource/connection string. My users want to be able to drill down in the pivot table to see the detailed data behind. All but 1 of my pivot tables seem to be working correctly. Basically, I'm using fields directly from my datasource - no calculated/formula field. As shown below example, I have 31 records for Bus1. When I double click, I get 1160 records which is the total count of records I have for CRA, I only want to see the 31 records that apply to Total Open/Pending which have an indicator of 1. I noticed that if I move the field (Total Open/Pending) to report filter, I get the 31 records ONLY, but this impacts the other field counts since some records may not apply to Total Open/Pending.

Thank you in advance for your help

Line of Business	#Total Open/Pending	#Ack Due Today	#Ack Due Tomorrow	#Ack Past Due	#Due Today	#Due Tomorrow	#Due Date PastDue	# of Escalated Requests	# of Escalated Requests not acknowledged >1 day	# of Requests for Add'l Information	# of Requests for Add'l Information > 1 bus day	Total Escalated to PPerformance MTD	Total Resolved MTD
Bus1	31	0	0	0	5	7	3	0	0	0	0	0	756

<tbody>
</tbody>

 

[mrshteam]

Smokey, did you ever resolve this issue? I am encountering the same thing using Excel 2010 and basic pivot table design - no slicers. I work at an insurance company and am counting certain types of claims. When I click on the number in the pivot table in a particular cell to see that list of claims, I am getting back all the claims, not those filtered by that particular type.

 

[bdunning]

I am having the same problem in Excel 2013 and also work with claims. When I click a sub set of my data or have it filtered, the drill down function is not working properly as it is pulling the entire data set back on a new tab. Any assistance on this from some of the pros would be greatly appreciated!

 

[bdunning]

Looks like I found the solution...if you are using slicers, you have to make sure that you also have those same filters in your pivot table for them to work. After I added the filters back to my pivot table and hit those rows, the drill down function worked Here is the link that I was able to reference for the fix:

Be Careful Drilling into PivotTables with Slicers – Bacon Bits