Expression for a column Total

[#1]

Hi All,

Could I define in a chart an expression for the total of a column that is different from its column expression?

Thanks,

Guy

[CELAMBARASAN · Accepted solution]

Hi,

     You can do that.

     Try with RowNo() function.

     =If(RowNo()>0,ColumnExpression,TotalExpression)

Celambarasan

[#3]

Thanks Celambarasan Adhimulam, its clear and working good as it looks!