Compare (Expression Value) with (Sum of Expression Values) in a chart

[timanshu]

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??

[jonathandienst]

Hi

You need:

Sum(Aggr(Expr1, Dim1, Dim2,...)) / Expr2

where

• Expr1 = first expression
• Expr2 = second expression
• Dim1, Dim2, ...   = all the dimensions of the chart/table

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

[timanshu]

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.