How can I get sum of a group cell with expression which aggregates the value from other group cells in SSRS? (to get weighted average)

Question

I have a dataset like this. This is how my SSRS Tablix and cell expression look like. I would like to calculate weighted average between "Count" and "Price" Is there any better way that manages to get weighted average between "Count" and "Price" for my Tablix in SSRS?

I multiply "Count" and "Price" through expression as the part with red font (i.e. 1387+3234) and expect to add up the part with red font to the cell highlighted as gray. Sadly, I have no idea how to add up the part with red font to the cell highlighted as gray. Any good suggestion?

Answer 1

Did you want the total of the Blue and Red sections or the Weighted Average?

For the total, you should be able to multiply the fields for each row and SUM them.

=SUM(Fields!COUNT.Value * Fields!PRICE.Value) 

For a weighted average, I believe you could SUM up the total value from each row and then divide by the overall COUNT.

=SUM(Fields!COUNT.Value * Fields!PRICE.Value) / SUM(Fields!COUNT.Value)