•1 min read•from 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?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#real-time data collaboration
#pivot table
#details tab
#count columns
#summary cell
#subset
#Excel
#filtering
#records
#results
#constraints
#x constraint
#y constraint
#fix