Removing zeros from Pivot

[ScottBeatty]

Is there a way to only display nonzero values in a Pivot Table

spreadsheet attached

[oeldere]

See the attached file.

I add the difference also in the reportfilter.

I selected everything except the 0 in the reportfilter.

[ScottBeatty]

Oh easy fix. Thank you!

[oeldere]

Thanks for the reply.

Glad i could help.

[cwise]

I am having the same issue excel my file is monstorous (over 250K lines) so I do not get all the values in the drop down to exclude the -0-. So I added a value filter on the pivot, that seem to work on the majority of the numbers; however, I still have some 0.00 and (0.00) displaying. The file I am working with is a dump from our A/P system that I am having to take the amount paid value and translate the currency to USD equivalent. We thoguht that the remaining 0.00 and (0.00) would be solved by rounding the calculation to 2 decimals. Unfortunately that isn't resolving the issue. They are still displaying.

Due to the size of the data and resulting pivot table (over 4K lines) I cannot in good conscience attach any portion of the large file, and I have attached a screen shot of one of the zero numbers (expanded) on the pivot table.