title: Excel Pivot Table: Hide rows where all measures are blank or zero
body: <p>I'm using powerpivot as datasource for my pivot table. Using Excel 2013.</p>
  
  <p>Just want to hide rows where all measures are blank or zero, like the one selected in the following image:</p>
  
  <p><a href="https://i.stack.imgur.com/N0xhR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N0xhR.png" alt="Trying to hide the selected row"></a></p>