This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi, I'm trying to sort values by 0 in a pivot table. I clicked on value filter equals 0 and then it doesn't show anything. Even though lots of rows contain zero. It will only return the blanks not 0. I tried all the value filters and they don't work. I tried less than 1 and it returns nothing. The data is in number format.
I have Microsoft 365 Excel version 2408
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi thanks, I asked someone on my team and they were able to help me get it to work.
Could you share a test file to reproduce your issue?
For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here. *Please make sure you have removed any sensitive or private information in the sample file before uploading.