Custom Totals

Hello,

I have a report that will show different metrics for different groups over time and I am looking for a way to add in different totals, as well as filter the date.

My report as of now looks like this:

What I would like to do from here is add the same conditional formatting to the totals that is on the percentage column, as well as the totals on the far right. My percentage calculation is a measure just takes the first metric and divides it by the second metric per week. I also want to only have dates in this report that are in the current quarter, or if it is the first week of a new quarter then the data will show for the entirety of the previous quarter. For example, in March I would like it to show dates in Q1, which is the current quarter, and in the first week of Q2 (April 1 - April 7) it will show the full totals from Q1. I would also only like to show dates that have data populated. I have a measure that will give a date a value of 1 if the end of the week date is less than today, aka has data populated, but when I apply it to my matrix it doesn't work properly. My measure is this:

Measure = IF( MAX( [End of Week] ) <= TODAY(), 1, 0)

I'm not sure if this is because my date values are the column headers, but I can't think of another way to do this dynamically.

Any help would be greatly appreciated! Thank you in advance!