How to calculate previous week

[ananyaghosh]

Hi,

I need to show previous week's data from the attached QVD based on the current date, means current date's previous week will be calculated and data will have to be shown according to that week.

Please let me know how to achieve that.

Thanks,

Sandip

[parul_mehta]

Please try this for the previous week calculation based on Order Date

Sum({<[Order Date] = {'$(=Date(Max([Order Date])-7))'}>}sales)

[parul_mehta]

Hi

Please check this. It works for last week calculation

[#4]

Hi Sandip,

Hope you are well.

Have you had a chance to look at the replies yet?