Forum Discussion
aykim101
Microsoft Employee
Microsoft EmployeeSum Total Row based on Weighted Average values above it
Trying to sum the values of a weighted average column using the records above the "Total" row I can only get the Total Row to use the same weighted average calculations as the rows above it P...
aykim101Microsoft Employee
Microsoft Employeethank you for the reply
that is the logic being used; however the "Total" row needs to sum the row values above it and NOT use the same Weighted Score calculation
v-yulgu-msftMicrosoft Employee
Microsoft EmployeeHi aykim101,
If you add a calculated column into table visual and enable the total row, the "Total" row will sum the row values above it automatically.
Regards,
Yuliana Gu