title: Excel pivot table: display rows filtered, but keep total for all rows (unfiltered)
body: <p>I have a pivot table where I filter the data by month. The thing is I need a total column for all months. Is it possible to somehow ignore a select column from being filtered? Or maybe there is a way to achieve it using calculated fields.</p>
  
  <p>Example:</p>
  
  <pre><code>October  500 clicks
  November 600 clicks
  December 1000 clicks
  </code></pre>
  
  <p>I use filter: <code>November</code></p>
  
  <p>I get a table:</p>
  
  <pre><code>google | 600
  </code></pre>
  
  <p>What I want to get after using this filter:</p>
  
  <pre><code>google | 600 | 2100
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/et1YU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/et1YU.png" alt="enter image description here"></a></p>