I am trying to create a custom earthwork report that shows earthwork quantities for bounded areas but then gives the total at the bottom of the breakdown.
The image below shows the breakdown but not the summation of the fills (it is just pulling the first fill value). I know in SQL I could accomplish this with a sum function but it appears that Word does not have the power to do that(I could be missing something). Could we get total cut and total fill added to the the list of values?
Also, is there a way to get the surface names not to repeat? They are repeating because they are referenced twice (for each boundary) but I do not need them to be.