Pivot table/chart: Filtering specific cells without removing whole row

**AndyPandy** · 01-12-2015, 05:48 AM

Hello,

As the title says, I am wondering if it is possible to filter out specific cells without having the whole row dissapearing in my pivot table. For example (see Book1.xlsx):

I want to filter out any values above 20 in the columns A-D. As an example, say I use the slicer for A to filter out the number 25. This filters out the whole row that the cell with 25 was in. I would like to keep the remaining numbers in that row in my table/graph. Is this possible?

Andy

**romperstomper** · 01-12-2015, 09:18 AM

Not with that data layout, no, because the filter will always exclude the whole row. You'd need the A, B, C and D entries to be items in one field rather than separate fields, but then you couldn't filter for a particular value in A for example - it would filter that value in all the items.

**AndyPandy** · 01-12-2015, 10:08 AM

Thanks Rory. I don't suppose there would be a different layout that could solve my issue? Having all items in the same field would defeat the purpose (the example is very simplified and the real data needs to be split into individual categories/columns)

**romperstomper** · 01-12-2015, 10:19 AM

Not really. In the attached workbook I have shown the layout I referred to. The pivot table looks the same as before but you cannot, as I said, filter a value specifically within A, B, C or D. For this specific example, you can however filter out the 25 you mentioned.