Home Forums Reporting Services Reporting Services Combine columns under category group - Pie chart RE: Combine columns under category group - Pie chart

  • February 9, 2018 at 10:52 pm

    #1979337

    Papil - Friday, February 9, 2018 1:50 PM

    Hi,

    I have a pie chart thats taking data from one of the dataset. My dataset has around 7 columns. Columns-A,B,C,D,E,F,G

    In Pie chart data under values- I am taking the count of two columns under values(= Count(A)+Count(B)). But for Category group i want to combine the two columns data as well column C and Column D. Can i combine the two columns data?

    Thanks.

    maybe create a calculated field in your dataset = Fields!A.Value + Fields!B.Value + Fields!C.Value + Fields!D.Value, and then use that calculated field instead of Fields A-D. (I do this if I want to lump a bunch of the fields together (say if they make up a really tiny percentage of the whole).