locked
SSRS display sum for sub category group by value. RRS feed

  • Question

  • User575167076 posted

    I have a table in below format

    criteria Year count
    A 2014 6
    A 2015 24
    B 2014 2
    B 2015 72

    I have a stacked chart with
    values =count
    categorygroup=criteria
    categorygroup1=year

    Now I have to display the data in the chart as percentage.
    The percentage should sum upto to 100 for a particular year.

    for example for 2014 it should be 6/(2+6) = 75% for criteria A and
    2/(2+6) = 25% for criteriaB.

    similarly for 2015 it should be 24/(24+72) = 25% for criteria A and
    72/(24+72) = 75% for criteriaB.

    The number of years is variable but no of criteria is 2(fixed).

    This percentage value should be displayed in the bars of column chart.

    Please help me to come out of this scenario.

    Thanks,
    Joy

    Wednesday, August 24, 2016 9:24 AM

Answers