Adding a total to a stacked column

Firebott

Hi all, I am creating a dashboard with a stacked column metric of tasks by department, priority, and status. The stacks are coming from a metric sheet (see print screen). The end user wants a total of tasks by department either placed under the department name or at the top of the stacked column. Is this doable? And if so, how? Thanks in advance.

Paul Newcome

You will need to flip your data so that departments are different rows and the statuses are the columns. Then you can use a formula in a text/number column to output the department with the total. Something along the lines of

="HR" + " (" + SUM([Not Started]@row:Low@row) + ")"

Then when you build your chart, you would use this new column as your labels.