topic Rolling N Month in Pivot Table in App Development

Rolling N Month in Pivot Table

deniscamh — Thu, 25 Jan 2018 18:25:36 GMT

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 — Thu, 25 Jan 2018 18:37:54 GMT

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 — Thu, 25 Jan 2018 18:48:06 GMT

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

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

deniscamh — Thu, 25 Jan 2018 19:15:56 GMT

Thanks For replay Pradosh

But what about two dimensions in Rows?

See my table screenshot

pradosh_thakur — Thu, 25 Jan 2018 19:19:35 GMT

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

deniscamh — Thu, 25 Jan 2018 19:23:15 GMT

No it is not.

It does not give the correct result.

pradosh_thakur — Thu, 25 Jan 2018 19:26:19 GMT

Did you try using before/after

deniscamh — Thu, 25 Jan 2018 19:32:30 GMT

No,

Let me take a look at this.

Thanks.

deniscamh — Thu, 25 Jan 2018 20:24:29 GMT

That is very helpful.

It seems working.

I will confirm as soon as I check all calculation

Thanks