Dashboards showing actual, total, and missing values

Options

I have a dashboard where I am viewing 3 data points (attended, missed, total students) related to attendance at various program locations. I would like the graph below to include the sum of the actual and missed at the top so we know the 'total' for each school on the horizontal axis.

Screen Shot 2022-05-10 at 11.51.40 AM.png

However when I add the 'total' data point, it throws the chart off since it adds the 'total' to the 'actual' and 'missed' bars (below). Is there a simple way to show the total for each column?

Screen Shot 2022-05-10 at 11.51.30 AM.png


Answers