Dynamically updating column

[David_Hahn]

I have an app that tracks employee hours and auto calculates total wages monthly per each employee.

Now, I would like to dynamicaly rename a column Total Wages whenever employee clocks out and thus recalculates all total wages.

I’ve used a concatenation formula in display field: "Total Wages "& [sum of all employee hours this month].

I’ve created virtual field “[sum of all employee hours this month]” which sums all employee total wages for this month.

But instead of column dynamicaly updating into (example):

-----Employee name—Total Wages (100 usd)-—Clock In—Clock Out

I only get Total Wages label.

-----Employee name—Total Wages-—Clock In—Clock Out

I hope I make sense.

Thank you in advance.