How to calculate previous week sales?

[Anonymous]

Hi All,

I have Date Slicer, by selecting the date i need to show Current week sales and Previous week sales (Both the reports are in different sheets)

For Example: If i select 19-6-2020, it shoud show the data for 19-6-2020 and 12-6-2020(previous week)

and if i select 12-6-2020, it should show the data for 12-6-2020 and 5-6-2020.

please help me.

Please find the below sample, if i select Date, then if i click on current report it should view current report and for the same date if i select previous report it should view previous report.

Kindly help me with the requirement.

Thanks!

Suresh.

[lbendlin]

Does your dates table have week numbers?

If not, what do you consider a week?

If you compare this week to last week, isn't that unfair?  Don't you want to compare the values week to date?  (Say, if today is friday and the week starts monday, then you only want to compare to last week's monday to friday)