Jun 01 2021 03:04 PM - edited Jun 01 2021 06:18 PM
Hello experts,
I need to filter out Zero (0) in a pivot table and I do not see how I can do that. The issue is that th column in question is a "difference from previous" and it seems that the filtering option is no longer an option for a column calculated this way.
Grateful for you assistance.
Please see attached sample file.
Jun 01 2021 09:55 PM
@Tony2021 Indeed, the built-in Filter option applies the "difference from" to the previous date displayed. Perhaps a more raw hack will work for you. Select cell K3 and switch on the auto filter.
This will insert filter buttons in row 3 of the pivot table. Now you can filter out the zero's from the Change column.
Jun 02 2021 05:14 AM - edited Jun 02 2021 05:16 AM
Hi Riny, thank you for the response but I have to say I do not see the option as described above. I click on the header called "Change", which is cell I3 and I right click and the below pic is what I see. I am not sure what I am doing wrong. thank you for the help.
Note: I am not sure why the pic below appears as an attachment instead of a viewable pic like you posted in your post. Maybe there is a hack for that?
Jun 02 2021 03:03 PM
Jun 02 2021 11:51 AM
Solution