All right. Same problem. Different solution.
The problem is still due to totals and subtotals being retrieved from the database and the database not knowing that you have hidden something in the client.
The solution I propose here is for a two-level hierarchy:
1. Keep the Total calculated row you did previously.
2. Add a new, custom calculation, as a calculated column:
if allcount(d1, all(c), m1) = 0 then sum(d1, 0, m1) else sum(d1, all(v,c), m1)
3. Optional: Go into your calculated Total, "Calculate in intersection", to include the new calculated column in the Total calculation.
Calc explanation: If you are at a node without children, then simply transfer the value, otherwise if you are at a node
with children (the subtotal nodes) then sum up all the visible children.
The solution complexity will increase if you have deeper hierarchies or if you have dimensions on the horizontal axis of your crosstab. Let me know if that is the case.
BR / Ole