Moving Average Problem

[#1]

I am facing some problem.

Below is my table:

  Date                    Price

6/30/2016	207.210007
6/29/2016	204.839996
6/28/2016	201.479996
6/27/2016	201.589996
6/24/2016	203.630005
6/23/2016	209.809998
6/22/2016	208.649994
6/21/2016	208.300003

Problem 1 I cannot calculate moving average 10 days in script, I only can moving average 2 days

rangeavg(Price,previous(Price)

Problme 2 Since I dont create the moving average field in the table but I want to add (Price > Moving average 10days Price) as calculated dimension

that is

=if(rangeavg(above(sum(Price),0,10))>0,1,0)

Can anybody give me some advices?

Thanks!

[#2]

Thanks!

[oknotsen]

If your question is now answered, please flag the Correct Answer and possible Helpful answers.

If not, please make clear what more information on this topic you are looking for .