I need to remove zero's from a pivot table and then define some simple stats on the pivot table results. I've tried using the Auto Filter option, which removes them visually but not from calculations. In other words, after using the Auto Filter to remove zero's, I calculate the min value for each column in the pivot table and still get zero for some columns. Any suggestions? Thank you.
Bookmarks