“Does it mean if I click on the field wells for Mask_Org and sort that by Total Fees, it will sort the column total of Week 2 and Week 3’s total fees?” – Correct
Yes some types of Table Calculations dont support subtotals/totals at this time (this looks like 2 nested table calcs)…
I might suggest doing the 3 columns (week 2, week 3 and diff) a different way. The only downside with this approach is the column headers would have to be generic (like ‘This week’, ‘Last Week’ rather than the specific week number).
It would be really easy to sort if you do it that way, and the report will look better (wont have the empty Diff column for the first period)