how to show last six week date in Pivot

[MMCGLAESASAA]

how to show last six week date in Pivot table based on current date

[Andrea_Bertazzo · Accepted solution]

Hi @MAR 

Thanks for the question.

It would be necessary to know more about your application and the fields you are using, but, in general, these problems can be resolved with a bit of set analysis in the measure.I would use something like

{$<Week = {">=Week(today())-6"}>}