Results 1 to 4 of 4

Need pivot table to eliminate rows where the value is zero

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2013
    Location
    New Mexico
    MS-Off Ver
    Excel 2010
    Posts
    38

    Need pivot table to eliminate rows where the value is zero

    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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1