Set column grand totals to SUM and row grand totals to AVERAGE (AVG) or the other way around. This methodology allows you to have two different aggregation calculations on your totals and grand totals using the INCLUDE function.
For consulting contracts, reach me through my LinkedIn account at / weston-palmer
Get your questions answered by supporting me on Patreon at / creators
Check out my Tableau Public Portfolio (a little out of date) https://public.tableau.com/profile/we...