title: Remove slicers involvement in a calculation
body: <p>I have two excel sheets I wan't to see the % diff between. </p>
  
  <p>Unfortunately they are both very different in the setup why I created some calculations.</p>
  
  <p>However, for some reason my Quarter slicer changes my calculation to be smaller than it is. </p>
  
  <p>See picture:</p>
  
  <p><a href="https://i.stack.imgur.com/sclau.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sclau.png" alt="enter image description here"></a></p>
  
  <p>Can I make my slicer not affect Q1 but only AMOUNT column?</p>
  
  <p>Thanks,</p>
  
  <p>PS: I can't create a Q1 calculation (summing Jan, Feb and March) from AMOUNT due to its format - I need the slicer.)</p>