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: