How do you create a pivot table and exclude it from showing the zero values?
i.e. I have a list of data..some with zeroes and some with dollar amounts. I only want to see the dollar amount fields not the ones with zeroes.