Home Forums Reporting Services Reporting Services Is Aggregation based on RowNumber possible? RE: Is Aggregation based on RowNumber possible?

  • June 30, 2016 at 4:04 pm

    #1887980

    Good strategy using RowNumber to filter unique values. Try the below SSRS expression (SUM the field only if the RowNumber field has a 1):

    =SUM(iif(Fields!rownum.Value = 1, Fields!ProductCost.Value, Nothing)