Referencing the attached image, how would one go about calculating the %Yield such that it is based on the cumulative values for columns A and B, where %Yield = (Cumulative Sum of B)/(Cumulative Sum of A)? Note that the %Yield values shown in the image are incorrect, except for the first Week.
Peace and All Good!
This is another of those "multiple aggregation" problems that come up on the forum from time to time, isn't it?
Only way I can think of is by doing the cumulative sums in custom SQL rather than using table calculations.