Pie chart filter not matching table data
Just getting started with a dashboard and I'm running into a sticky problem. I tried to apply a filter to a pie chart and noticed that the numbers weren't adding up, so I duplicated the chart and turned it into a simple table. The table adds up perfectly. I'm applying the following filter to data coming from Sheets:
The table matches my sheets data perfectly:
The pie chart includes 24 "other" entities, four of which, presumably, are the four departments not listed explicitly listed in the chart's legend. The other 20 are unaccounted for:
Any suggestions would be helpful. Thanks!