Average is correct, but Grand Totals not correct, weighted average?

Content

I have the following table that provides insights into last weeks performance.  The TTF / TTS are producing straight averages in the grand total and it's not weighted by how many actually accepted or started.   Thoughts on how I can get grand total to reflect the true value?   I believe in a pivot table it would account for this but I don't think my data set is appropriate for a pivot table.

Here's the formula for TTS to provide an example:

Avg((case when timestampadd(sql_tsi_day, -dayofweek(min(current_date)) -5, min(current_date)) < "Submission Dates"."Offer Actual Start Date" and timestampadd(sql_tsi_day, -dayofweek(min(current_date)) +1, min(current_date)) > "Submission Dates"."Offer Actual Start Date" then TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Fully Approved Date", "Submission Dates"."Offer Actual Start Date") end))