Is there a way to only display nonzero values in a Pivot Table
spreadsheet attached
Is there a way to only display nonzero values in a Pivot Table
spreadsheet attached
See the attached file.
I add the difference also in the reportfilter.
I selected everything except the 0 in the reportfilter.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Oh easy fix. Thank you!
Thanks for the reply.
Glad i could help.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks