Use specific field values to perform calculations

I am trying to create a calculated field to find average, but I want to work with the total for that column instead of each value.


I am looking to do sum(total)/count(total). But total is not a column name so I cannot really access values in x,y,z. Is there another approach I could try?

You can try sumOver or countOver