TommyDenn Member

@lthomas If the earlier doesn't work - Use a fixed function in the Beastmode. I think this option is best.

You should be able to follow the referenced steps. This article references AVG but should work as SUM too… https://community-forums.domo.com/main/discussion/61660/pivot-table-total-and-subtotals-are-not-the-sum-but-the-aggregation-function

Thanks a ton for the thorough response. Several solid options mentioned. Will probably end up suppressing the single line values as it's most visually appealing.