Comparing Last week, 2 weeks ago sales

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.