title: TABLEAU Totals not matching what's in view
body: <p>I've been dealing with this issue in various ways throughout my time with this dataset in Tableau.</p>
  <p><img src="https://i.stack.imgur.com/Cq7qK.png" alt="image of Table and Calculated Field together" /></p>
  <p>As you can see, the Total count of properties for each city is including properties that have been successfully filtered out of view. Why? The <em>dyn.RANKED Profitable Investments (grouped)</em> variable on the Filter shelf is an attempt to double down on the same as the first line of the Calculated Field - to ignore the unwanted properties in each city. The view ignores them, but the totals do not.</p>
  <p>If the Watershed Property pill is removed from the Rows shelf, then the <em>dyn.NumProps_in_City</em> results shown on the table are each the same as the Totals you see here (i.e., despite the first line of the calculated field, properties that do not meet that opening condition are being counted)...despite the view <em>with</em> the Watershed pill knowing not to show them.</p>
  <p>Also if the Watershed Property pill is removed from the Rows shelf, then the <em>dyn.RANKED Profitable Investments (grouped)</em> variable on the Filter shelf suddenly only has one category to choose from (i.e., 'INVEST') if you go to edit the filter. Which would be great since that's the category I care about, but not if the counts are including things that are not in that category despite the filter.</p>
  <p>Messing around with Include, Exclude, and Fixed in the calculated field doesn't seem to work here since I can't figure out how to get around various aggregate/non-aggregate and/or ATTR errors no matter where I place them. Plus, my incorrect counts are not suffering from an LOD issue - the LOD is correct - it's an issue of <em>not consistently filtering out the unwanted rows</em> at the desired LOD.</p>
  <p>Please advise!
  Thanks,
  Christian</p>