Hi there, I'm having a problem with the attached workbook. Data is on Sheet 1 (ignore table to the left, it's inconsequential to the pivottable). In sheet 7, the pivot table, I need rows where quantity is zero not to be included. Example: under 4713, example 1, quantity is blank. I don't want it to show 4713 at all. I want the table to start with 4775 Example 3. How do I accomplish this?
Bookmarks