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
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi aykim101,

 

Have you worked it out? If so, would you please kindly mark the corresponding reply as an answer? If not, please feel free to ask.

 

Regards,

Yuliana Gu

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