Stacked chart based on sub grouped data.

[KFR]

I have a data translation that has 2 levels of grouping. How can I turn this into a stacked chart?

E.g. My data looks like this after grouping it on Field1 and the Field2:

Field1 | Field2 | Total
Value1| ValueA| 1
Value1| ValueB| 3
Value2| ValueA| 3
Value2| ValueB| 2
Value3| ValueA| 4

I want to turn this into a stacked chart, where the there is a bar for value1, value2 and value3 which is divided into the totals for Field2. This is very easy to do in most reporting software, but I can't seem to figure out how to do it in stimulsoft reports. Do you have any hints on how to achieve this?

[Lech Kulikowski]

Hello,

Could you send us a sample in Excel that shows what you want for analysis?

Thank you.

[KFR]

I have attached an excel example of the chart I am trying to achieve. The data in the spreadsheet basically represents the result of my data transformation.

[Lech Kulikowski]

Hello,

You can use the AutoSeriesKeyDataColumn property.

Thank you.

[KFR]

Perfect, thank you. I knew there had to be an option I was missing, but I couldn't find any documentation explaining it.

[Lech Kulikowski]

Hello,

You are welcome.