Ok Mr. Benjamin, that was pretty scary.
I wiped countless hours on this and you got in minutes basically.
Nice job with the LOD calc and the second calc on top.
Have successfully translated to my personal workbooks.
Big thanks again,
now that I have the core results in, will be coming back to see if these results could be graphed on time series.
Glad to help! Ever since LOD calculations were introduced in Tableau 9, I always fall back on using them over table calculations for things like percent of total. They're so much more customizable and don't rely on the layout of the table to return the correct answer.