12 month roll

[#1]

Hi,

Can anyone help me create an expression for measuring 12 rolling sales.

Thomas

[#2]

Hi Thomas,

Here's an example of a 3 month rolling average using the rangesum and above functions. Hopefully you can adapt this to you setup.

This article by gwassenaar  is also a great resource:

Calculating rolling n-period totals, averages or other aggregations

Best,

Matt

[#3]

Hi Matt,

Thanks for your reply.

It issue with this is that when you choose a specific month it shows the sales for that month and not the 3 month rolling avg.

Regards,

Thomas

[#4]

Ok, what about ignoring the date dimension like this:

rangeavg(above(sum({<YourDateField = >}Sales),0,3))

Best,

Matt

[#5]

Hi Thomas, try with this set analysis in your expression: Month= {">=$(=max(Month)-12)<=$(=max(Month))"}

Hope it helps you!

Regards!

[#6]

I can't really ignore the date dimension since I will choose a specific month to see numbers for that month.

Thomas

[#7]

In this.

Rangeavg(above(sum({<Month = >} Sales), 0,12))

?

[#8]

There is a little example, I use Q (1,2,3,4) as dimension, and a simple sum with the expression given in the last post. The dimension will be filtered by the range in the expression

Hope it helps!

Regards!

[#9]

Hmm....this gives me the same as a simple SUM.

:

[#10]

So you need a total InvoiceQuantity of the last 12 months in a single row?