Create a chart from grouped data

[andystark]

I have a data returning in a data set that looks like this:

Department 1 Product Name Units
Department 1 Product Name Units
Department 2 Product Name Units
Department 2 Product Name Units
Department 3 Product Name Units
Department 3 Product Name Units

I have added a Group Band that will group by Department and in the group footer band a summary that will sum units by Department.

I want to show a bar chart with the Department as the argument and the Units as the value. But all I get in the report is each record repeated in the chart, i.e. not grouped by Department. Do I need to define a relationship and use that as argument in the chart series?

[Alex K.]

Hello,

In this case, you can add additional data source - "Data from Other Data Source" with necessary grouping and then use it in the Chart.

Thank you.