Rolling Period with Average

[priyarane]

Hi Community,

I have show rolling period for 3 months(which I knew) but at the same time we should show average for the 3 months like below in Pivot table/ if possible in straight table.

Expre: Sum({<Rolling period for 3 Months with the help of Month ID>}Sales)
Dim: Month	Dec	Nov	Oct	Sum(all months)/3

- Priya

[marcus_sommer]

Take a look here: Calculating rolling n-period totals, averages or other aggregations

- Marcus

[antoniotiman]

Hi,

see attachment.

Regards,

Antonio

[jyothish8807]

Hi Priya,

I dont think your requirement can be achieved using single pivot chart.

Try to create a pivot with rolling 3 sales and other one with Avg of rolling 3 month sales and keep it below the first one.

Keep the dimension same for both the charts.

This is a work around, will let you know if something comes in to my mind.

Regards

KC

[priyarane]

Thanks Antonio for your reply. Is it possible for rolling period.

My rolling expression for ex: sum({<Month={'>=$(=max(Month)-2)<=$(=max(Month))'}>}Amount)

[antoniotiman · Accepted solution]

Yes, instead of RangeAvg() and Sum(Value).

Divide by 3 or (dynamically)

/Count({<Month={'>=$(=max(Month)-2)<=$(=max(Month))'}>} DISTINCT Month)