This is the case where Excel shines, but Tableau struggles.
What you've asking for looks like a simple calculation --
The problem with doing this in Tableau is two-fold.
First, one should have 'a-new-cell' somewhere on a view,
and this implies having a distinct dimension(s) value(s)
to create such a cell, or using data densification to create
a potential cell to fill in a value, or using custom Totals for that.
Neither approach is working in this case (imho),
because of the initial complications (right from the start)
when making bins by the Table Calc ( [Transformations] ).
So one outta "fall-back" to a dashboard approach --
combining the bins view (that one on the Sheet 7)
with the Net calc single-row view (that one on a Sheet 7a).
Please find the attached with a dashboard like the above.
Hope this could help.
PS The alternative would be to "push-down" the "binning" table calc
to build a FIXED LOD custom bin dimension. But this would require
re-shaping data or even doing datasource-specific coding (with Custom SQL).
Frankly, I'm not ready to propose that kind of solution yet.
workbook_x_net_YF.twbx 79.3 KB