I'm filling a report with a table that looks like this:
Code | Data
AAGU | AAGU = 41.43%; BCGS = 40.68%;
BCGS | BCGS = 41.43%; OTHER = 34.98%; XXX = 2%;
So my question is, how can I create a chart where each slice is one of the values that are separated by a semicolon?
This is what I tried so far,
- Created a
Matrix
with theRows
section filled with the value of theCode
column. - Inserted a
Pie Chart
in TheData
section - In the
Values
section of thePie Chart
I used the following expression:
=Split(Fields!Data.Value, ";").Length
This is what I got:
Each Code
row has a pie chart but only a single value: which is the entire data string. It was never splitted.
How can I achieve what I am looking for?