i have a first column with a calculated label.
in another column (i call it TOTAL) i use column(1) to reference it.
If i move the first column in second position, column(1) in TOTAL will still reference the first column of the table.
How can i reference my col so that even if i move it, the reference in TOTAL will still be ok.
(That's a probleme of calculated label i can't use to reference the col)
Just instead of using Column() use Expression label, so even if you change the position of the expression you don't need to change the expression.
Expression Label : Total Sales
Expression : = Sum(Sales)
Expression = [Total Sales] + (Some Calculation)
Hope this helps you.