Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SSRS Nested SUM ( IIF Expression Need to Group By Date Please Help

I am new to SSRS and have a SUM(IIF question.   My data set contains four columns: Date, GroupID, PlanPaid, and NetworkIndicator.   Here is an example of the data set:   I am trying to SU...
  • AlexisOlson's avatar
    4 years ago

    Adding the "Claims_Rolling12" argument means that it's summing over that context instead of just the local context.

     

    In this case, I think you can stick with just Sum(Fields!PlanPaid.Value) and put a NetworkIndicator filter on the entire Tablix.