Thanks for your suggestion. I had already tried that which is why I'm posting the question. Instead of an actual total I get a grand total that shows as blank. No * or null value, just nothing. Would you know why that is or how to fix? Thanks for all your help!
Because Tableau calculates Grand Totals only for multiple items within a measure, not across different measure values.
Tableau does not compute Subtotals and Grand Totals as just an aggregation (Sum, Avg, etc.) of the displayed marks. Instead, Subtotals and Grand Totals are computed as a separate calculation of the Measure at a coarser level of granularity. In other words, you may be expecting the total to be computed as an aggregate of an aggregate (like a total Sum of an Avg Sales per Department), and Tableau computes Subtotals and Grand Totals as the original measure at a higher level of aggregation (for example, the Avg of Sales measure computed across all Departments).
A Grand Total for columns is computed as if there there were no Dimension pills on Rows. For a SUM() measure this looks the same as a Sum of Sums, but for an AVG() measure the Grand Total is an Avg computed across every row. If you have more complex calculated fields, then it can get even more complicated. There are a variety of techniques to customize Subtotals and Grand Totals to get desired results. Follow below mentioned links
I hope this may help you.
Did you find the solution for your question. Cuz I too in need of the solution.