Last weeks sales

[shophoney]

Hi I’m looking for a way to have sales starting last Monday for the week.

Below is what is use for today’s sales. What formula will pull sales starting Monday.


= CUBEVALUE("ThisWorkbookDataModel",
"[Measures].[SALES TOTAL NET RETAIL]",
"[SALES TABLE].[TRANS DATE].&[" & TEXT(TODAY(), "yyyy-mm-ddThh:mm:ss") & "]"
)

Thanks.