title: Filtering top 10 elements in pivot table does not show expected rows
body: <p>I am using the excel's pivot table to sort and filter data from Super Store Dataset from <a href="https://community.tableau.com/docs/DOC-1236" rel="nofollow noreferrer">tableau</a> . Here is a screen shot of my output.</p>
  
  <p><a href="https://i.stack.imgur.com/hYtTQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hYtTQ.png" alt="enter image description here"></a></p>
  
  <p>The steps that I followed are:</p>
  
  <pre><code>a. Put Order Date in the Rows. 
  b. Put Sub-Category in the Columns.
  c. Put the Profit in the Sum of Values.
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/uOddM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uOddM.png" alt="Data Placement"></a></p>
  
  <p>After that I took these steps:</p>
  
  <pre><code>d. Sort the Grand Total of the Sub Category from largest to smallest.
  e. Sort the Grand Total of Order Date from largest to smallest.
  f. Filter Top 3 from the Sub-Category.
  g. Filter Top 10 from the Order Date.
  </code></pre>
  
  <p>And the above image of an excel sheet shows my output.</p>
  
  <p><strong>Now the problem is , even though the excel sheet was supposed to show me the <code>top 10</code> orders , it only manages to show 7 to 8 orders. The rest 2 to 3 of them are either blank or should not even belong to the <code>top 10</code> category.</strong></p>
  
  <p><a href="https://i.stack.imgur.com/EvCkP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EvCkP.png" alt="enter image description here"></a>  </p>
  
  <p>Does anybody knows why is this happening. And how can this be prevented. 
  Thanks.</p>
  
  <p>Edit: This is how the top 15 looks like : 
  I believe top 10 is based on the vertical Grand Total and it should also be a subset of the top 15.</p>
  
  <p><a href="https://i.stack.imgur.com/i8aFx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/i8aFx.png" alt="enter image description here"></a></p>
  
  <p>And this is the top 20 :</p>
  
  <p><a href="https://i.stack.imgur.com/2Tf0v.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2Tf0v.png" alt="enter image description here"></a></p>