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
many thanks in advance
Solved! Go to Solution.