Data agrupation for charts

[victorinable]

Hi,

Good afternoon. I was trying to create a Chart in a report with different columns from a unique dataset. The issue I've found is that I really don´t know if there is the possibility to group data that's feeding the chart.

So, If I have a employees table, with a Field "Sex", I would like to know how much M, W and people per period. So what I did is create a Dataset with 2 columns, sex and numberOfEmployees. Add 2 series, one filtering per "M" other one filtered by "W", but how to create a serie including all both Sex's?? Should I create another DataSet? There is a way to sum all columns in a Expression?

Thanks in advance.

[Alex K.]

Hello,

Most probably, in this case, you need use the additional data source.

Should I create another DataSet? There is a way to sum all columns in a Expression?

Please try to use the Totals.Sum(DataSourceName, ColumnName) function.

Thank you.