Home Forums Reporting Services Reporting Services 2008 Development How to add a subtotal to only 3 out of 4 accounts being grouped on a Balance Sheet RE: How to add a subtotal to only 3 out of 4 accounts being grouped on a Balance Sheet

  • April 27, 2016 at 2:20 am

    #1874871

    You can include a condition within your aggregate expression which will then be evaluated for each row being aggregated.

    E.g.

    =Sum(Iif(Fields!AccountType.Value = "Cash and Short-Term Investments", 0, Fields!Balance.Value))