Comparing Last week, 2 weeks ago sales
1) Create calculated field like below,
Name: Last Week Sales
Syntax: if datediff('week', [Date_Field], today()) =1 then [Sales] end
2) Create another calculated field like below,
Name: 2 Weeks ago Sales
Syntax: if datediff('week', [Date_Field], today()) =2 then [Sales] end
3) Drag the Date field into work Area,Right click on Date field on the work area, then click on more (First more) then click on "Weekday"
4) Drag the above 2 calculated fields into work area.
5) Now you can see the what you want on the Report.
