title: Excel Pivot Table-Hiding specific Column Value
body: <p>I have a pivot table that looks like below.</p>
  
  <pre><code>Critical        
  Yes No  Total
  1   3   4
  1   2   3
  3   0   3
  4   1   5
  </code></pre>
  
  <p>I need to Hide the No column from the pivot but shouldn't impact total column. I have tried using Hide "No" column but that changes the value in Total field.
  TIA.</p>