Community Trekker

Joined:

Sep 29, 2014

## How to Rolling Average

Hi All,

I have a column which displays the actual sales day bay day. I would like to have a column which takes the average of last seven days (Rolling Average)? As a result the first 6 row is missing and the data starts on 7th fo the first 7 days mean at 8th the 2nd to 8th rows mean, at 9th the 3rd to 9th mean...and so on

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Joined:

Jun 23, 2011

Solution

## Re: How to Rolling Average

Try this column formula :

If(Row() > 6,

Mean(:Sales[Index(Row() - 6, Row())])

);

3 REPLIES

Super User

Joined:

Jun 23, 2011

Solution

## Re: How to Rolling Average

Try this column formula :

If(Row() > 6,

Mean(:Sales[Index(Row() - 6, Row())])

);

Community Trekker

Joined:

Sep 29, 2014

## Re: How to Rolling Average

Thank you!

Community Trekker

Joined:

Sep 29, 2014

## Re: How to Rolling Average

Hi MS,

Would you please show me how to add "by variable" to the script above?

Sales by Year,

Sales by Year by Agency

Sales By Year by Agency by Month...