Hi,
I am using excel 2010 and am attempting to drill down to counts. The problem is that all items in the row are returned in the drill down and does not take the column into account. Is there a way to change a setting or something to drill down to the exact records included in the count? I know an option would be to filter, but that is ugly and I have to exclude blanks. Any suggestions would be appreciated

Thanks,
Lauren