Forum Discussion

aykim101's avatar
aykim101
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Sum 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...
Need Help
aykim101's avatar
aykim101
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

i still cannot get the total row to sum the weighted score rows above it

 

what do you mean by "add a calculated column"?

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi aykim101,

 

What I meant "Add a calculated column" is creating a column rather than measure.

 

Could you please teel me in your scenario, whether above fields [Count], [Percent of Total], [Average Score] and [Weighted Score] are columns or measures?

 

Regards,
Yuliana Gu