Showing previous months sales - Set Analysis.

[#1]

Hi there,

Trying to get my previous sales from last month subtracted from the current sales this month, so it shows the amount of sales (less or more) than the previous.

My current set analysis:

Count({<Month={">=$(=MonthStart(AddMonths(Max(Month),-1))) $(=MonthStart(AddMonths(Max(Month),0)))"}>}Sales_total)

This giving the wrong result, obviously. Not too sure how to structure my analysis. Any assistance would help.

Thanks.

[sunny_talwar]

Both of them are great points