I have a pie chart which shows total spend by customer. I am able to apply filters in the dahsboard by date so for example March to July spend. If a customer placed business in February, but then had a refund in March, the March spend for that customer is a negative value (which is ok). However when I filter the data to show March to July spend only my pie chart displays an error message which says "positive and negative values in chart" and displays no chart. I fully understand why it is doing this, but I want my data in a Pie Chart, and I want to be able to filter by date. Is there any way around this? Is there a way to get the pie chart to ignore negative values when filtering for example? Thanks. Jenny.
