Search code examples
matrixgraphchartsreporting-servicesreporting

SSRS Chart with a Matrix

I have following Matrix and chart created. Currently the chart uses Sum(PO_COUNT). Matrix uses the expression, =(Sum(Fields!PO_COUNT.Value)/Sum(Fields!PO_COUNT.Value,"TEAM"))*100 for Data section. Matrix presents data as percent of row total. The chart need to use the same data field as the Matrix .The chart need to present the same data and values as Matrix. If I change the chart's values section to use the expression =(Sum(Fields!PO_COUNT.Value)/Sum(Fields!PO_COUNT.Value,"TEAM"))*100, it gives me the following error message

enter image description here enter image description here

I re-wrote the expression based on the error message but none worked

Solution

  • From what you have said so far, it seems you could just use a 100% stacked chart and then you would not need to calculate anything for the chart