Summing different fields on a group by

  • HI

    I have a data set with student info; Name, Type

    there would be multiple lines for each student

    Soemthing like

    StudentA, Type1

    StudentA, Type2

    StudentB, Type1

    StudentC, Type2


    I want a matrix where its grouped by student then have two columns, Type1, Type2

    Output to be:

    STudent     Type1     Type2

    StudentA      1            1

    StudentB       1

    StudentC                   1


    I have tried =Sum(iif(Fields!type.Value = "Type1" ,1, 0), "DataSet1")  for type1

    but the counts arent correct




    Sorry after looking at my output, that's exactly what I did use matrix instead of a tablix 🙂



Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply