• I figured out how to do it for the weekly total rows...

    =iif(InScope("Date2"), sum(Fields!Sales.Value), last(Fields!Sales.Value))

    Now the conundrum lies in trying to total the total columns correctly