I have this calculated field:
MIX = avg({TOTAL SHIPMENTS SC1}) * coalesce({CARRIER MIX DIFF}, 0) * coalesce({CPS PLAN DIFF SC2}, 0)
However in the total row, of course it does not show the total sum. So I wanted to create a ‘summary table’ with all the the totals of the formulas in table 1 (it contains different calculations per type and region.
And because of the avg formula I cannot have another calculated filed to do Total = sum(MIX)
I tried doing sumOver(MIX), and it does show the total ONLY in table 1, same result (the total) for all rows, including the total row. I dont want to have this column in table 1, only in table summary, works only if the columns type and region are there, but then it would not be a summary table, it would be the same as table 1.
Hello @belengim, if you are alright with switching the solution from having the total value in the same table rather than in a different summary table, I think I can resolve your initial problem. I was testing some calculated fields to solve the request, but I think if we just update the total calculation in the table, you can retrieve the correct values.
I’ll include a link to an Arena dashboard with the solution I am proposing. My fields are different than yours, but I think this is the desired outcome: Total of a sumOver() or Calculated field with avg()
By selecting the 3 dots in the field well next to your calculated field, you can switch the calculation for the total value to sum. Let me know if this resolves the problem you are facing!
