Excel: Pivot Table Does Not Filter
<p>I have a spreadsheet that has similar data to (except I have 256K rows):</p>

<pre><code>Company $
A       10
A       20
A       30
B       20
B       30
C       40
C       60
D       10
D       0
D       10
</code></pre>

<p>I created a Pivot Table where the Rows are grouped by <code>Company</code> and the Values show the sum of <code>$</code>.</p>

<p>I am trying to have it filter for values where the <code>sum of $</code> is <code>&gt;= 50</code>. So I go to Filter for <code>$</code> and do greater than or equal to 50</p>

<p><a href="https://i.stack.imgur.com/2t7lz.png" rel="noreferrer"><img src="https://i.stack.imgur.com/2t7lz.png" alt="enter image description here"></a></p>

<p>When I do this, nothing is changed. I know I can always manually select every value where the value is >= 50 but that would take a long time because my data has too many rows.</p>

<p>I tried adding a column in my data to return the sum of $ by comparing Company name (<code>=SUMIF(A:A,"="&amp;A2,B:B)</code>)but that would take a very long time for 256K rows.</p>

<p>What am I doing wrong with my filtering? Why isn't it actually filtering based on value? </p>