Result based on previous months

[#1]

Hi, I'm trying to sum 12 values for each month, based on the "ThisMonth" values of the previous 12 months.

ThisMonth is just a sum: Sum(InvoiceQuantity)

And for the sake of this demo, I've been able to calculate "Prev Months" by:

RangeSum(Below(TOTAL Sum(InvoiceQuantity),1,12))

The problem with this, is that I'm stuck with this specific order. I want to remove this dependency.

Also, I can only calculate the RangeSum on values I'm displaying in the table. If I filter out a month, say ReportingMonth 9, then my "Prev Month" value loses that number.

I want to be able to calculate this sum, even if the months needed for the calculation aren't displayed in the table (filtered out, for example).

[stigchel]

Have a look at this

https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table#comment-49905