I have a data source which is a database table where I group the number of active customers by SalesOwner.
What I want to do is filter my sheet using SalesOwner so that I can make a bar chart that contains one of SalesOwners together with the Grand Total. 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.
Is there a way around this? A bar chart with just one of SalesOwners and the total?