title: Display filtered value and grand total in the same sheet
body: <p>I have a data source which is a database table where I group the number of active customers by SalesOwner.
  <a href="https://i.stack.imgur.com/LIhyF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LIhyF.png" alt="enter image description here"></a></p>
  
  <p>What I want to do is filter my sheet using SalesOwner so that I can make a bar chart that contains one of SalesOwners <em>together with the Grand Total</em>. What happens as of now is that when I filter my data and select one SalesOwner, the Grand Total obviously shows the grand total of that one filter.</p>
  
  <p>Is there a way around this? A bar chart with just one of SalesOwners and the total?</p>