MTD for whole month versus the selecting week.

[dwighttrumbower]

I'm creating a table visual where it shows, daily, weekly MTD, QTD and YTD. 

The filters are Year, Month, Week.

When I select 2005, Feb, 8th week my MTD, QTD and YTD only show for that week. Is there a way to code those so it uses all the available days in the MTD, QTD and YTD?

Right now I use this for MTD: 
SUM({<Year={'$(vMaxYear)'},Month={'$(vMaxMonth)'},Date=,MonthYear=>}DealerCostUSD)

Thanks

[dwighttrumbower]

I think I figured it out.

SUM({<Year={'$(vMaxYear)'},Month={'$(vMaxMonth)'},Day=,InvoiceDate=,Week=>}DealerCostUSD)