title: Removing blank Excel Pivot Table entries
body: <p>I have a pivot table based on PowerPivot with multiple levels in the Rows section. Quite a few of the elements are blank. Is there a way to suppress the blank rows?</p>
  
  <p>My Pivot Table looks like this at the moment.</p>
  
  <pre><code>Product1
      Release 1
          Iteration 1
              (blank)
          Iteration 2
              (blank)
      Release 2
          (blank)
              (blank)
  Product2
      (blank)
  Product3
      Release 1
          Iteration 1
              Sprint 1
              (blank)
          (blank)
  (blank)
  </code></pre>
  
  <p>This is what I want it to look like</p>
  
  <pre><code>Product1
      Release 1
          Iteration 1
          Iteration 2
      Release 2
  Product2
  Product3
      Release 1
          Iteration 1
              Sprint 1
  </code></pre>
  
  <p>That's just an example. I've tried to set filters for each level not to display blanks but if I filter each level to hide blank fields the pivot table doesn't have any items in it. It seems that Excel ends up filtering each level out that has ANY blank values.</p>
  
  <p>Not sure if I made sense or provided enough information for troubleshooting. I'm pretty much brain dead at the moment so I apologize.</p>
  
  <p>Please let me know if it doesn't make sense or if I can provide any additional information to clarify what I'm trying to do and encountering.</p>
  
  <p>Thanks.</p>
  
  <p>EDIT: Changed the code block to be more clear and added an "after" code block to show what I want to get to. I guess the issue is that the "depth" of the rows for the entire pivot table has to be equal. For example if I have 3 indents for the first item, the others must also show 3 levels of indent worth of data. If I hide blanks and that results in 1 indent worth of data for the first item, it will hide non-blanks for other items as well if they appear after 1 indent. Still not sure if that makes any sense :) I need some sleep.</p>