1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Show Details tab in pivot is not filtering

Hello! I have a pivot table with several count columns and every time I click into a summary cell to see the details tab, the results are for the entire subset and not for the subset that matches the cell I clicked. Ex: click summary cell with count of 9 (records that meet x and y constraints), get results for 112 (records that meet x constraint only). Does anyone know how to fix this?

submitted by /u/amor106
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article