SSRS Matrix – Sum fields in a row group but avoid duplicates

If you want to avoid the duplicates for a row group field for the grand total of a row group. Use builtin MAX or MIN aggregate functions for the field that will be used in the sum function.

Wrong implementation
= SUM(Fields!Amount.Value)

Correct Implementation
= SUM(MAX(Fields!Amount.Value, “NameOfRowGroup”))