Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Ranjit,
Try to create variable: vTotalSale=SUM(TOTAL Sale)
Regards,
Sokkorn
Thanks Jonathan, you are right, i used Sum(Aggr()), i got the result!!