title: Excel Pivot filtering on calculated fields
body: <p>Calculated fields are awesome BUT there are restrictions such as not being able to sort through it (impossible to move the field to the Report Filters area).</p>
  
  <p>I have tried "forcing" a filter like Microsoft's guys suggested : <a href="https://answers.microsoft.com/en-us/office/forum/office_2010-excel/filtering-a-pivot-table-on-a-calculated-field/31312a31-8e9a-401b-acb0-ed575d9cb397" rel="nofollow noreferrer">https://answers.microsoft.com/en-us/office/forum/office_2010-excel/filtering-a-pivot-table-on-a-calculated-field/31312a31-8e9a-401b-acb0-ed575d9cb397</a> but it appeared to be a very bad idea.</p>
  
  <p>So instead, I tried sorting using VBA with my code here : <a href="https://stackoverflow.com/questions/49236773/excel-filter-pivot-between-two-values-from-a-calculated-field">Excel filter pivot between two values (fast)</a>
  but it didn't work on the calculated field either.</p>
  
  <p>How to use a calculated field just like any regular field?</p>
  
  <p>Thank you</p>