Sorting the Data as per Last Month Sales Volums

1) Create a calculated field like below to get the Last month Sales Volume

if

year([Order Date]) = year(today())

and

month([Order Date]) = month(today())

then

sum(sales])

end

2) Then drag all required fields onto work area, then right click on Dimension which you want to custom sort, click on "Sort" then select field, then pick above calculated field.