Dashboards showing actual, total, and missing values
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.
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?