Calculation 12 -
WINDOW_SUM(SUM([Profit]), FIRST()+1, 0)
Because of the +1, you have at least 1 row every time that doesn't return a value (the +1 is telling Tableau to ignore the first value). If it doesn't return a value, Tableau can't sum it.
As a quick fix, removing the +1 means the totals work.
WINDOW_SUM(SUM([Profit]), FIRST(), 0)
thinking out loud... maybe you need a 2nd formula based on the output of calculation12 to deal with the 'blank' rows before you total
hope that helps, a little
Wow mark, worked like magic
Thanks a Ton
Great news, You're welcome!