Show Previous Month Data in the Report for Regions.

1) Create a Calculated field as below.

Name: Previous Month Sales

Syntax: if year([Order_Date])= year(today()) and month([Order_Date])= month(today())-1

then ([Sales]) end

2) Drag the [Region] on to Rows shelf, [Previous Month Sales] onto Columns Shelf.