If you want to filter to the maximum then it must be date instead of Week Number
Use DATE function to convert your calculation to date then it will give the selection to have maximum date whenever the workbook is opened so change your calculation to below
DATE(DATETRUNC('week',[Created Dtm]) - DATEADD('week',7,DATETRUNC('month',[Created Dtm])))
Hope this helps. Plz mark this answer as correct or helpful to close the thread
I want the filter to be shown as week and when the workbook is opened ,it should filter to the latest week.