Display sum/total of pivot table in a variable

[renjithpl]

Hi All,

Is there a way to show one of the column total from a pivot table in a variable or a text box.?

Regards

Ranjit

[jonathandienst]

Hi

You cannot reference the values in a chart or table; to recalculate the value, use the chart column expression in an sum(aggr(...)) expression, using the chart dimensions as the dimensions in the aggr clause.

If you provide more information, someone will be able to provide more specific assistance.

Regards

Jonathan

[Sokkorn]

Hi Ranjit,

Try to create variable: vTotalSale=SUM(TOTAL Sale)

Regards,

Sokkorn

[renjithpl]

Thanks Jonathan, you are right, i used Sum(Aggr()), i got the result!!