Need help to show previous 6-Week data from the given date in the reports in Matrix Chart

[Aasish]

Hi,

I have a table which has below fields:

1. ID

2.BU

3.Orgin Area

4.Destination Area

5.Start Date

6.End Date

7.Total Orders

8.Total Commitments

9.Week End Date

I need to filter the report to show previous 6-week ends based on the date slected. For Eg: If the Date Selected is 2017/11/8 then it should show the data of previous 6-week ends(WeekEnding Date) as  2017/11/04,2017/10/28,2017/10/21,2017/10/14,2017/10/07,2017/09/30.

Note: I have calculated total commitments and order and derived the weekend in SQL query itself. But i just want to filter the weekend column to prev 6 weekend in the report based on the user input date and show the data as below:

Can anyone please help me on this ?