title: Remove zero rows from Google Sheets pivot table
body: <p>I have a pivot table to aggregate some financial balance by counterparties.
  <a href="https://docs.google.com/spreadsheets/d/1ccwdK8aNjVJWGx2i_Oci9VnmjRdCYiiEgYFpW8gZShg/edit?usp=sharing" rel="nofollow noreferrer">Link to the example.</a></p>
  
  <p>Over time, it's expected that the aggregate amount for most of the parties will be 0. I want to show only those rows in the pivot table where the aggregate is nonzero. Otherwise, my pivot table will be cluttered by tons of empty zero rows.</p>
  
  <p>In the <a href="https://docs.google.com/spreadsheets/d/1ccwdK8aNjVJWGx2i_Oci9VnmjRdCYiiEgYFpW8gZShg/edit?usp=sharing" rel="nofollow noreferrer">above example</a>, this corresponds to hiding John, Mary, and Thomas records.</p>
  
  <p>Is there a way to accomplish this?</p>