Expression Help Please

[jameswills]

I'm after some hep with the syntax for an expression in a chart please?

I have three dimensions:

Period, Account and GLActual

I'd like to construct a combo chart with two expressions:

Sum(GLActual) as a column, which I can do no problem 🙂

I would then like a flat line which shows 80% of the average of the sum of selcted periods, please see examples below where Series 1 is the basic actual sum and series 2 the 80% average of the cumulatie:

Any help would be greatly appreciated.

[sunny_talwar · Accepted solution]

May be this

Avg(TOTAL Aggr(Sum(GLActual), Period)) * 0.80