I've read through some of the issues of grand totals when aggregating calculated fields, and how tableau struggles with averages, mins, and maxes since it calculates across and not strictly the total of all values below.
The solutions did not work for me (window_sums, TOTAL() function, etc) since I am using blended data. My calculation contains a min nested within a max, based on several other columns. Below is my function. How can I get the correct column total?