Sales per Business Day Total
I have a dataset that is structured in the following
Columns: Date, Segment, # Units Sold, and Goal Units Sold.
Rows are by day and segment. (6 segments, 6 rows for each day)
It is joined with a calendar dataset containing a column for the count of business days.
My goal is a table metric, like the attached, that shows # of Units Sold per business day by segment, with a total showing the total Sum of the units sold per business day. What I'm getting with the attached beast mode calculation and table metric seems to be the right rows counts, but then the total is an average, rather than a sum total of the segments combined. How can I end up with the total row equaling the sum of the rows?