Month on Month comparison over 12 months

[#1]

Hi, I hope you guys can I've read quite a few posts that are similar to this one, but can't seem to get anything to work for me.

I'm looking to analyse sales data from a month and compare it to the previous months figures and show what the difference is.

I can easily show the month and the sales results from it as in columns 1 & 2, but I wanted to create the data in columns 3 & 4.

Column 3 shows the data from column 2 in the previous month and column 4 is column 2 minus column 3

The dimension is UNIT.SOLD_MONTH and column 2 expression is  sum(UNIT.TOTALSOLD)

Any ideas greatly welcomed, thanks Simon.

Sold Month	Month Units	Previous Month Units	Variance
May-15	148	173	-25
Apr-15	173	103	70
Mar-15	103	97	6
Feb-15	97	107	-10
Jan-15	107	82	25
Dec-14	82	203	-121
Nov-14	203	185	18
Oct-14	185	163	22
Sep-14	163	117	46
Aug-14	117	224	-107
Jul-14	224	169	55
Jun-14	169	0	169

[martinpohl]

see attached

Regards

or use

RangeSum([Month Units],-[Previous Month Units]) as Variance

[giakoum · Accepted solution]

Calculating rolling n-period totals, averages or other aggregations

[#4]

Hi Martin, thanks for your reply, however I need this to be dynamic, so if I select a different buyer I get results that are relevant to them. Thanks

[#5]

Hi, thanks for this, I was able to use rangesum to create a 2 month total then take the month units from the rangesum total to give me the desired result

[#6]

rangesum(Below(sum(UNIT.TOTALSOLD),0,2))