Rolling N Month in Pivot Table

[deniscamh]

Hi All,

I have a pivot table with two Rows dimensions and Month-Year as column dimension.

I need the formula avg(score) in expression will display the result of rolling three month for each month.

Means for January 2018 it should show result for Nov 17, Dec 17 and Jan 18.

I red about rengesum and rangeaverage but it seems working in straight table but not pivot.

Any thoughts please?

[azrahim71]

We have the same question.. We work with Rolling Months, Rolling Quarters, Rolling Years.

Would love to get some help on this type of question. this is

Another is about MASTER Calendar...

[pradosh_thakur]

can you sort the month in ascending order and use something similar to

rangeavg(above(total avg(score),0,3))

[deniscamh]

Thanks For replay Pradosh

But what about two dimensions in Rows?

See my table screenshot

[pradosh_thakur]

Is it working ? Not sure i follow what you want to say here.

[deniscamh]

No it is not.

It does not give the correct result.

[pradosh_thakur · Accepted solution]

Did you try using before/after

https://community.qlik.com/docs/DOC-8205

[deniscamh]

No,

Let me take a look at this.

Thanks.

[deniscamh]

That is very helpful.

It seems working.

I will confirm as soon as I check all calculation

Thanks