Forum Discussion
Solved
filter out 0 in pivot table
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 fi...
Tony2021 See attached.
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?
Tony2021 See attached.
- I got it now. I thought in your response above when you referred to K3 I thought it was a type since K3 is outside of the pivot but it seems this is a a hack. I see now. Very nice indeed.
thank you.