Summary:
This article details how to have a SUM of values with filters (ex. any amounts over 5,000,000)
Method:
Use the SUMIF Excel statement with the greater than (>) symbol. Be sure to add quotes around the calculation. For an expanding group, expand the range one row beyond the group so that it expands.
=SUMIF(D8:D10,">500000",D8:D10)
Properties:
BI360
Excel
Report Designer