Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have an issue , where I have a chart (Pivot or any other) with Dimensions and an Expression with name suppose Expr.
Now, with in the chart I want a new expression Expr 2 that gives output as Sum of all Expr values / Expr2 Value.
How can this be possible??
Hi
You need:
Sum(Aggr(Expr1, Dim1, Dim2,...)) / Expr2
where
For example, say expr1 = Sum(Sales) and expr2 = Count(Lines). In a table with dimensions Month, Year:
Sum(Aggr(Sum(Sales), Month, Year)) / Count(Lines)
HTH
Jonathan
Hi Jonathan,
It is not working .
I applied it on straight/pivot table.
Only Sum(Aggr(Sum(Sales), Month, Year)) part of expression is giving 0 in every row.