Pivot table total and subtotals are not the sum but the aggregation function
I want my table to have the column aggregated as average while ensuring that the overall total corresponds to the sum. Currently, the Domo pivot table allows the column aggregation to be average but total and subtotal are also averages instead of sums.